`
swvip
  • 浏览: 150470 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

ORA-14133: ALTER TABLE MOVE cannot be combined with other operations

SQL 
阅读更多

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>

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics