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
