Oracle之创建表与修改表详解(六)
OK5 USERS
MYBOOK5_1 USERS
EMP_TEST USERS
BOOKS_01 USERS
已选择37行。
SCOTT@orcl#alter table book4 move tablespace system;
表已更改。
SCOTT@orcl#select table_name,tablespace_name fromuser_tables where table_name='BOOK4';
TABLE_NAME TABLESPACE_NAME
------------------------------------------------------------------------------------------------------------------------
BOOK4 SYSTEM
SCOTT@orcl#alter table book4 move tablespace users;
表已更改。
SCOTT@orcl#alter table book4 pctfree 5 pctused 60;
表已更改。
SCOTT@orcl#drop table book4 cascade constraints;
表已删除。
SCOTT@orcl#show recycle
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ -------------------------------
BOOK4 BIN$2ZVssaoayV/gQKjABIkd1g==$0 TABLE 2013-04-05:13:00:49
BOOKS_01 BIN$2ZVssaoTyV/gQKjABIkd1g==$0 TABLE 2013-04-05:12:44:32
BOOKS_01 BIN$2ZVssaoOyV/gQKjABIkd1g==$0 TABLE 2013-04-05:12:34:47
BOOKS_01 BIN$2ZVssaoJyV/gQKjABIkd1g==$0 TABLE 2013-04-05:12:21:41