SQL> CREATE TABLE ernp TABLESPACE tbsfd AS SELECT * FROM hr.employees;
Table created.Further, you executed the following command to drop the table: SQL> DROP TABLE ernp;
Table dropped. What happens in this scenario?
A- The table is moved to the SYSAUXtablespace.
B. The table is moved to the SYSTEM tablespace.
C - The table is removed from the database permanently.
D - The table is renamed and remains in the TBSFD tablespace.Answer : D为什么删除了那个表后它会改名并且依然存在于原来的表空间中呢?
我刚做了个实验确实如此. ORACLE这样做的目的是什么呢?难道不会造成空间浪费吗?
Table created.Further, you executed the following command to drop the table: SQL> DROP TABLE ernp;
Table dropped. What happens in this scenario?
A- The table is moved to the SYSAUXtablespace.
B. The table is moved to the SYSTEM tablespace.
C - The table is removed from the database permanently.
D - The table is renamed and remains in the TBSFD tablespace.Answer : D为什么删除了那个表后它会改名并且依然存在于原来的表空间中呢?
我刚做了个实验确实如此. ORACLE这样做的目的是什么呢?难道不会造成空间浪费吗?
等于是把 drop 掉的表放入了回收站。要永久删除,需要:
DROP TABLE ernp purge;
可以恢复被DROP掉的表空间吗?
要是Drop掉的表空间是不能恢复的吧,呵呵,没有试过!
在“恢复对象”的下拉菜单中有TABLESPACE,我一开始以为是可以恢复被DROP掉的表空间。
可是我刚才做了下实验,DROP掉的表空间是不能使用flashback tablespace aaa to before drop语句进行恢复的。所以我觉得OEM里那个“TABLESPACE恢复对象类型”可能指的是恢复表空间里的某些内容吧?? 是这样吗?