1、创建是要用表test

SQL>create table test as select table_name,tablespace_name from user_tables;

SQL>select * from test where rownum<5;

SQL>commit；

2、将tablespace_name列置为无用

SQL> alter table test set unused (tablespace_name);

SQL>select * from test where rownum<5;

3、恢复

切换管理员身份

SQL>conn  sys  as  sysdba

查询TEST表在数据库中分配的编号

SQL> SELECT OBJ# FROM OBJ$ WHERE NAME='TEST';

SQL> SELECT COL#,INTCOL#,NAME FROM COL$ WHERE OBJ#=13251;

SQL> SELECT COLS FROM TAB$ WHERE OBJ#=13251;

SQL>  UPDATE COL$ SET COL#=INTCOL# WHERE OBJ#=13251;

SQL> UPDATE TAB$ SET COLS=COLS+1 WHERE OBJ#=13251;

SQL> UPDATE COL$ SET NAME='TABLESPACE_NAME' WHERE OBJ#=13251 AND COL#=2;

SQL> UPDATE COL$ SET PROPERTY=0 WHERE OBJ#=13251;

SQL> commit;

重启数据库

SQL> shutdown immediate

SQL> startup

验证