oracle 丢失索引,oracle 索引丢失后的恢复

2019独角兽企业重金招聘Python工程师标准>>>

索引丢失或则索引失效之后，在不进行数据库恢复的情况如何解决？下面会模拟索引丢失的情况。

1    新建一个表空间tmp0408

create tablespace tmp0408 datafile '/u01/oracle/oradata/orcl/tmp0408.dbf' size 10m;

SQL> create tablespace tmp0408 datafile '/u01/oracle/oradata/orcl/tmp0408.dbf' size 10M;

Tablespace created.

SQL> select file#,status,name from v$datafile;

FILE# STATUS NAME

---------- ------- --------------------------------------------------

1 SYSTEM /u01/oracle/oradata/orcl/system01.dbf

2 ONLINE /u01/oracle/oradata/orcl/sysaux01.dbf

3 ONLINE /u01/oracle/oradata/orcl/undotbs01.dbf

4 ONLINE /u01/oracle/oradata/orcl/users01.dbf

5 ONLINE /u01/oracle/oradata/orcl/user02.dbf

6 ONLINE /u01/oracle/oradata/orcl/tmpspace0327

7 ONLINE /u01/oracle/oradata/orcl/tmp0408.dbf

2    在刚建的表空间tmp0408 中创建表emp 字段ename的索引index_emp_ename_i

SQL> create index INDEX_EMP_ENAME_I on emp(ename) tablespace tmp0408;

Index created.

SQL> select index_name,table_owner,table_name,tablespace_name from user_indexes where table_name = 'EMP';

INDEX_NAME TABLE_OWNE TABLE_NAME TABLESPACE_NAME

-------------------- ---------- -----