FLASHBACK DROP TABLE
SCOTT@orcl SQL>conn test_user/test_user;
已连接。
TEST_USER@orcl SQL>create table test_tab(name varchar2(10));
表已创建。
TEST_USER@orcl SQL>create index test_idx on test_tab (name);
索引已创建。
TEST_USER@orcl SQL>alter table test_tab add constraint test_cons primary key (name);
表已更改。
TEST_USER@orcl SQL>select object_name,object_type from user_objects;
OBJECT_NAME OBJECT_TYPE
-------------------------------------------------------------------------------------------------------------------------------- -------------------
TEST_IDX INDEX
TEST_TAB TABLE
TEST_USER@orcl SQL>set linesize 1000;
TEST_USER@orcl SQL>select constraint_name,constraint_type,table_name from user_constraints;
CONSTRAINT_NAME C TABLE_NAME
------------------------------ - ------------------------------
TEST_CONS P TEST_TAB
TEST_USER@orcl SQL>drop table test_tab;
表已删除。
TEST_USER@orcl SQL>select * from user_recyclebin;
OBJECT_NAME ORIGINAL_NAME OPERATION TYPE TS_NAME CREATETIME DROPTIME DROPSCN PARTITION_NAME CAN CAN RELATED BASE_OBJECT PURGE_OBJECT SPACE
------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- --- --- ---------- ----------- ------------ ----------
BIN$QTriIDWWQN+RP7EI7daCAQ==$0 TEST_IDX DROP INDEX USERS 2011-12-30:14:09:07 2011-12-30:14:10:46 2931725 NO YES 53526 53526 53527 8
BIN$DFHwt3pQRhK6qSGhpBXm4w==$0 TEST_TAB DROP TABLE USERS 2011-12-30:14:08:50 2011-12-30:14:10:47 2931730 YES YES 53526 53526 53526 8
TEST_USER@orcl SQL>flashback table test_tab to before drop;
闪回完成。
TEST_USER@orcl SQL>desc test_tab;
名称 是否为空? 类型
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NAME NOT NULL VARCHAR2(10)
TEST_USER@orcl SQL>select object_name,object_type from user_objects;
OBJECT_NAME OBJECT_TYPE
-------------------------------------------------------------------------------------------------------------------------------- -------------------
TEST_TAB TABLE
BIN$QTriIDWWQN+RP7EI7daCAQ==$0 INDEX
TEST_USER@orcl SQL>alter index "BIN$QTriIDWWQN+RP7EI7daCAQ==$0" rename to test_idx;
索引已更改。
TEST_USER@orcl SQL>select object_name,object_type from user_objects;
OBJECT_NAME OBJECT_TYPE
-------------------------------------------------------------------------------------------------------------------------------- -------------------
TEST_TAB TABLE
TEST_IDX INDEX
TEST_USER@orcl SQL>select constraint_name,constraint_type,table_name from user_constraints;
CONSTRAINT_NAME C TABLE_NAME
------------------------------ - ------------------------------
BIN$jSyjUKjxTpKr0R7DWxlmSw==$0 P TEST_TAB
TEST_USER@orcl SQL>alter table test_tab rename constraint "BIN$jSyjUKjxTpKr0R7DWxlmSw==$0" to test_cons;
表已更改。
TEST_USER@orcl SQL>select constraint_name,constraint_type,table_name from user_constraints;
CONSTRAINT_NAME C TABLE_NAME
------------------------------ - ------------------------------
TEST_CONS P TEST_TAB
TEST_USER@orcl SQL>drop table test_tab purge;
表已删除。
TEST_USER@orcl SQL>conn sys/sfis as sysdba
已连接。
SYS@orcl SQL>drop user test_user cascade;
用户已删除。
SYS@orcl SQL>spool off;