Oracle OCP IZ0-053 710(Recyclebin&Tablespace Quato)

710. You executed the following commands in a database session:

Which statement is true about the contents of the recycle bin in this situation?
A.They remain unaffected.
B.They are moved to flashback logs.
C.They are moved to the undo tablespace.
D.They are moved to a temporary tablespace.
E.The objects in the recycle bin that are in the default tablespace for the session user are cleaned up.
Answer:E


驗證：建立了一個使用者，並且預設表空間之分配了1M的配額。
        可以看到，因為表空間配額不夠，所以，recyclebin的內容被create table命令清除了。
        嘗試flashback, 提示物件已經不在回收站裡
       

SQL> create tablespace ts_test datafile '/u01/app/oracle/oradata/inst1/ts_test.dbf' size 100M autoextend off;


Tablespace created.


SQL> create user mytest identified by mytest
  2    default tablespace ts_test
  3    temporary tablespace TEMP
  4    profile DEFAULT
  5    password expire;


User created.


SQL> alter user mytest quota 1m on ts_test;


User altered.


SQL> grant connect to mytest;


Grant succeeded.


SQL> grant create table to mytest;


Grant succeeded.


SQL> create table mytest.test01 tablespace ts_test as select * from dba_objects
  2  where rownum <= 1000;


Table created.


SQL> conn mytest/mytest       
ERROR:
ORA-28001: the password has expired




Changing password for mytest
New password: 
Retype new password: 
Password changed
Connected.
SQL> drop table test01;


Table dropped.


SQL> select object_name,original_name from recyclebin
  2  /


OBJECT_NAME                    ORIGINAL_NAME
------------------------------ --------------------------------
BIN$Losw5djDFabgUwEAAH+Dvw==$0 TEST01


SQL> create table mytest.test01 tablespace ts_test as select * from dba_objects;
create table mytest.test01 tablespace ts_test as select * from dba_objects
*
ERROR at line 1:
ORA-01536: space quota exceeded for tablespace 'TS_TEST'




SQL> select object_name,original_name from recyclebin;


no rows selected


SQL>  flashback table test01 to before drop;
 flashback table test01 to before drop
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2061144/，如需轉載，請註明出處，否則將追究法律責任。