SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
TEMP
EXAMPLE
INDX
USERS
PERF
7 rows selected.
SQL> create table test(a number);
Table created.
SQL> select tablespace_name from tabs where table_name='TEST';
TABLESPACE_NAME
------------------------------
SYSTEM
SQL> alter table test move users;
alter table test move users
*
ERROR at line 1:
ORA-14133: ALTER TABLE MOVE cannot be combined with other operations
SQL> alter table test move tablespace users;
Table altered.
SQL> select tablespace_name from tabs where table_name='TEST';
TABLESPACE_NAME
------------------------------
USERS
SQL>
SQL> drop table test;
Table dropped.
SQL>
ORA-14133: ALTER TABLE MOVE cannot be combined with other operations
最新推荐文章于 2021-04-03 05:20:07 发布