FlashBack & Recycle Bin

FlashBack & Recycle Bin. 1

Da li je recyclebin uključen. 1

Struktura recyclebin. 1

Koji objekti su unutra. 1

Flashbak tabele int_admin_emp u int2_admin_emp. 2

Da li je RecycleBin uključen?

USER is "SYS"

SQL> show parameter recyclebin

NAME TYPE VALUE

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

recyclebin string on

Struktura RecycleBin

SQL> desc RECYCLEBIN

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

Koji objekti su unutra?

SELECT OBJECT_NAME, ORIGINAL_NAME, TYPE FROM RECYCLEBIN

/

OBJECT_NAME ORIGINAL_NAME TYPE

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

BIN$KT4OmD+LTciRDnw+j3iyQQ==$0 RADNIK TABLE

BIN$jybCD+RdT8qNU+wOybglnw==$0 SYS_C004627 INDEX

BIN$ABPAXqHYSf2kbr4Fv3kpjw==$0 INT_ADMIN_EMP TABLE

Flashbak tabele int_admin_emp u int2_admin_emp

SQL> FLASHBACK TABLE int_admin_emp TO BEFORE DROP RENAME TO int2_admin_emp;

Po potrebi vraćanje starog imena indeksa

SQL> SELECT INDEX_NAME FROM USER_INDEXES WHERE TABLE_NAME = 'INT2_ADMIN_EMP';

INDEX_NAME

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

BIN$zvTOxMKYRb+UFJLJNvv1/Q==$0

SQL> ALTER INDEX "BIN$zvTOxMKYRb+UFJLJNvv1/Q==$0" RENAME TO SYS_C004627;

Index altered.

SQL> SELECT INDEX_NAME FROM USER_INDEXES WHERE TABLE_NAME = 'INT2_ADMIN_EMP';

INDEX_NAME

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

SYS_C004627