ORA-08002: sequence SEQ.CURRVAL is not yet defined in this session
2019-03-26oerr ora 8002
08002, 00000, "sequence %s.CURRVAL is not yet defined in this session"
// *Cause: sequence CURRVAL has been selected before sequence NEXTVAL
// *Action: select NEXTVAL from the sequence before selecting CURRVAL 阅读全文...
expdp直接导入远程的数据到本地
2019-03-25也可以直接导入远程的数据到本地 阅读全文...
nagios check_oracle_health ERROR OCIEnvNlsCreate
2019-03-19本地可以执行，nagios服务器执行错误 阅读全文...
ORACLE中科学计数法显示问题的解决
2019-03-19在sqlplus 中显示的是科学计数法，设定以下可以不用科学计数法显示： 阅读全文...
oraInventory目录的作用
2019-03-14What is oraInventory ?oraInventory is repository (directory) which store/records oracle software products & their oracle_homes location on a machine. This Inventory now a days in XML format and called as XML Inventory where as in past it used to be in binary format & called as binary Inventory.
There are basically two kind of Inventory Global Inventory (also called as Central Inventory) and Local Inventory also called as Oracle Home Inventory. 阅读全文...
UNIX平台orainstRoot.sh脚本作用
2019-03-14使用Oracle Universal Installer（OUI）在UNIX平台上安装Oracle软件的快结束的时候会提示我们要执行orainstRoot.sh脚本。 阅读全文...
oracle冷备份无法启动
2019-03-12数据库硬盘坏了，有rsync复制的没有shutdown的冷备份。 阅读全文...
ORA-00059 maximum number of DB_FILES exceeded
2018-11-28ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded 阅读全文...
使用impdp数据泵导入并重命名表名
2018-08-28使用数据泵导入并重命名表名 阅读全文...
rman-0level全备份及恢复
2018-08-21rman需要提前开启归档模式。 阅读全文...
oracle清理v$archived_log记录
2018-08-21v$archived_log 记录越来越多，如何清理记录？ 阅读全文...
oracle glogin.sql
2018-08-07sqlplus如果经常定义set linesize 200，可以将配置保存到glogin.sql. 阅读全文...
nagios监测dbbak
2018-07-12nagios配置 阅读全文...
oracle限制远程访问
2018-07-04连接Oracle时报错ORA-12541是我们最常遇到的错误。 阅读全文...
给left join关联关系字段加索引
2018-07-04left join是相当耗资源的操作,如果关联的字段没有索引的话,速度是很慢的,所以如果有left join的话,最好用索引字段取关联。 阅读全文...