1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103
| SQL> conn / as sysdba
Connected.
SQL> show parameter recyclebin
NAME TYPE VALUE
--------------------- ----------- ------
recyclebin string on
SQL> conn hr/hr
Connected.
Name Null? Type
----------------------- -------- -------------
OBJECT_NAME NOT NULL VARCHAR2(30)
ORIGINAL_NAME VARCHAR2(32)
OPERATION VARCHAR2(9)
TYPE VARCHAR2(25)
TS_NAME VARCHAR2(30)
CREATETIME VARCHAR2(19)
DROPTIME VARCHAR2(19)
DROPSCN NUMBER
PARTITION_NAME VARCHAR2(32)
CAN_UNDROP VARCHAR2(3)
CAN_PURGE VARCHAR2(3)
RELATED NOT NULL NUMBER
BASE_OBJECT NOT NULL NUMBER
PURGE_OBJECT NOT NULL NUMBER
SPACE NUMBER
SQL> select object_name,original_name,type from user_recyclebin;
no rows selected
SQL> drop table regions_bis;
Table dropped.
SQL> select object_name,original_name,type from user_recyclebin;
OBJECT_NAME ORIGINAL_NAME TYPE
------------------------------ --------------- -----------------
BIN$M958iDMLSwiRr1va7ePQ0A==$0 REGIONS_BIS TABLE
SQL> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
REGIONS_BIS BIN$M958iDMLSwiRr1va7ePQ0A==$0 TABLE 2005-11-27:16:11:53
SQL> desc regions_bis;
ERROR:
ORA-04043: object regions_bis does not exist
SQL> -- maintenant on restaure la table avant le DROP dans son nom original
SQL> FLASHBACK TABLE regions_bis TO BEFORE DROP;
Flashback complete.
SQL> desc regions_bis;
Name Null? Type
--------------------- -------- -------------
REGION_ID NOT NULL NUMBER
REGION_NAME VARCHAR2(25)
SQL> select object_name,original_name,type from user_recyclebin;
no rows selected
SQL> drop table regions_bis;
Table dropped.
SQL> -- On restaure la table et on en profite pour la renommer
SQL> FLASHBACK TABLE regions_bis TO BEFORE DROP RENAME TO regions_bis_repetita;
Flashback complete.
SQL> desc regions_bis;
ERROR:
ORA-04043: object regions_bis does not exist
SQL> desc regions_bis_repetita;
Name Null? Type
--------------------- -------- ---------------------------
REGION_ID NOT NULL NUMBER
REGION_NAME VARCHAR2(25)
SQL> -- Maintenant on supprime définitivement la table regions_bis_repetita:
SQL> drop table regions_bis_repetita;
Table dropped.
SQL> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
REGIONS_BIS_REPE BIN$LwfJR8+sTp2bksjHK5b3AQ==$0 TABLE 2005-11-27:16:21:30
TITA
SQL> purge recyclebin;
Recyclebin purged.
SQL> show recycle_bin;
SQL> |
Partager