| General |
| Related Data Dictionary Objects |
| recyclebin$ |
recyclebin |
| dba_recyclebin |
user_recyclebin |
|
| |
| Flashback Dropped Table |
Flashback Table From The
Recycle Bin Using The Object
Name |
FLASHBACK TABLE <object_name> TO BEFORE DROP
{RENAME TO <new_table_name>}; |
SELECT object_name, original_name
FROM recyclebin;
CREATE TABLE test (
testcol VARCHAR2(20));
ALTER TABLE test
ADD CONSTRAINT pk_test
PRIMARY KEY (testcol)
USING INDEX
PCTFREE 0;
INSERT INTO test VALUES ('ABC');
INSERT INTO test VALUES ('DEF');
COMMIT;
SELECT * FROM test;
DROP TABLE test;
SELECT object_name, original_name
FROM recyclebin;
FLASHBACK TABLE "BIN$RfMyTuf+R7inKCbOiSay9g==$0"
TO BEFORE DROP;
SELECT * FROM test;
SELECT table_name, constraint_name, constraint_type
FROM user_constraints
ORDER BY 1;
ALTER TABLE test
RENAME CONSTRAINT "BIN$1tDo7RSYSmyca9yoqNvxPA==$0"
TO pk_test;
SELECT table_name, constraint_name, constraint_type
FROM user_constraints
ORDER BY 1;
SELECT table_name, index_name
FROM user_indexes
ORDER BY 1;
ALTER INDEX "BIN$Rnkss3raTSyTya7CVU+iZA==$0" RENAME TO pk_test;
SELECT table_name, index_name
FROM user_indexes
ORDER BY 1;
DROP TABLE test PURGE; |
Flashback Table From The
Recycle Bin Using The Original Name |
FLASHBACK TABLE <original_table_name> TO BEFORE DROP
{RENAME TO <new_table_name>}; |
CREATE TABLE test (
testcol VARCHAR2(20));
INSERT INTO test VALUES ('ABC');
COMMIT;
SELECT * FROM test;
DROP TABLE test;
CREATE TABLE test (
testcol VARCHAR2(20));
INSERT INTO test VALUES ('DEF');
COMMIT;
SELECT * FROM test;
DROP TABLE test;
CREATE TABLE test (
testcol VARCHAR2(20));
INSERT INTO test VALUES ('GHI');
COMMIT;
SELECT * FROM test;
DROP TABLE test;
SELECT object_name, original_name, droptime
FROM recyclebin;
FLASHBACK TABLE test TO BEFORE DROP;
FLASHBACK TABLE test TO BEFORE DROP
RENAME TO test2;
FLASHBACK TABLE test TO BEFORE DROP
RENAME TO test1;
SELECT * FROM test;
SELECT * FROM test2;
SELECT * FROM test1; |