Flashback Drop scenario

The tested scenario for the flashback drop feature.

SQL> select * from tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
D TABLE
SYS_TEMP_FBT TABLE
C TABLE
N TABLE
B TABLE
A1 TABLE

6 rows selected.

SQL> drop table c;

Table dropped.

SQL> select * from c;
select * from c
*
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> select * from recyclebin;

OBJECT_NAME ORIGINAL_NAME OPERATION TYPE TS_NAME
------------------------------ -------------------------------- --------- ------------------------- ----------
BIN$PRtTP+PTTlqWRcW9NnHSRg==$0 C DROP TABLE USERS

SQL> select autoextensible from dba_data_files;

AUT
---
YES
YES
YES
YES

SQL> alter database datafile 4 autoextend off;

Database altered.

SQL> select file_name,autoextensible from dba_data_files;

FILE_NAME AUT
---------------------------------------------------------------------- ---
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF NO
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF YES
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF YES
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF YES


SQL> create table flashbk (no number);

Table created.

SQL> insert into flashbk select object_id from dba_objects;

49836 rows created.

SQL> /
insert into flashbk select object_id from dba_objects
*
ERROR at line 1:
ORA-01653: unable to extend table NV.FLASHBK by 128 in tablespace USERS


SQL> select * from recyclebin;

no rows selected