Database
1.physical
2.logical
Select * From dba_tablespaces
Select * From dba_data_files
Select * From dba_temp_files
Select * From dba_segments Where tablespace_name='A'
Select * From dba_extents Where segment_name = 'TA'
Database -> Tablespace -> segments -> Extents -> blocks -> os blocks
Select * From dba_tablespaces
Create Tablespace A Datafile 'C:\oracle\product\10.2.0\oradata\testDB\A.ORA' Size 20M
Create Table TA(Id Int) Tablespace A; --指定TABLE,TA的数据存放在表空间A中,表的定义仍然存放在当前用户的表空间
Alter Tablespace A Offline; --将表空间A离线
--此时不能访问表TA,但是可以删除表的定义即不能select与update,但是可以drop
Select *From TA --ORA-00376: 此时无法读取文件 5 ORA-01110: 数据文件 5: 'C:\TABLESPACE\A.ORA'
Drop Table ta
Sql>show Recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TA BIN$XhfWyKMsTuSSqsVMnTgBwA==$0 TABLE 2013-12-30:20:23:32
Alter Tablespace a Online;
Select * From "BIN$XhfWyKMsTuSSqsVMnTgBwA==$0"
Flashback Table ta To Before Drop --闪回表TA
1.physical
2.logical
Select * From dba_tablespaces
Select * From dba_data_files
Select * From dba_temp_files
Select * From dba_segments Where tablespace_name='A'
Select * From dba_extents Where segment_name = 'TA'
Database -> Tablespace -> segments -> Extents -> blocks -> os blocks
Select * From dba_tablespaces
Create Tablespace A Datafile 'C:\oracle\product\10.2.0\oradata\testDB\A.ORA' Size 20M
Create Table TA(Id Int) Tablespace A; --指定TABLE,TA的数据存放在表空间A中,表的定义仍然存放在当前用户的表空间
Alter Tablespace A Offline; --将表空间A离线
--此时不能访问表TA,但是可以删除表的定义即不能select与update,但是可以drop
Select *From TA --ORA-00376: 此时无法读取文件 5 ORA-01110: 数据文件 5: 'C:\TABLESPACE\A.ORA'
Drop Table ta
Sql>show Recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TA BIN$XhfWyKMsTuSSqsVMnTgBwA==$0 TABLE 2013-12-30:20:23:32
Alter Tablespace a Online;
Select * From "BIN$XhfWyKMsTuSSqsVMnTgBwA==$0"
Flashback Table ta To Before Drop --闪回表TA
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15810196/viewspace-1130227/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15810196/viewspace-1130227/