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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8520577/viewspace-2061144/