数据库 | 等闲之辈莫等闲

table/index/LOBINDEX迁移表空间

2019-04-02

1、alter table tablename move tablespace tbs_name
2、select 'alter index '||index_name||' rebuild tablespace $lts;' from user_indexes;
3、当我们建立一个含有lob字段的表时，oracle会自动为lob字段建立两个单独的segment,一个用来存放数据(LOBSEGMENT)，另一个用来存放索引(LOBINDEX)，并且它们都会存储在对应表指定的表空间中。但是当我们用alter table tablename move tablespace tbs_name 来对表做空间迁移时，只能移动非lob字段以外的数据。而如果我们要同时移动lob相关字段的数据，我们就必需用如下的含有特殊参数据的文句来完成，它就是： alter table tablename move lob(columeName) store as (tablespace newTableSpaceName);
这样，就将这两个对象从老的表空间移至新的表空间。阅读全文...

ORA-08002: sequence SEQ.CURRVAL is not yet defined in this session

2019-03-26

oerr 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-14

What 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. 阅读全文...