本篇内容主要讲解“数据库中怎么解决修改表名时遇到ORA-14047错误”,感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷,实用性强。下面就让小编来带大家学习“数据库中怎么解决修改表名时遇到ORA-14047错误”吧!
SQL> show user;
USER is "TEST"
SQL> create table rename_table ( id int);
Table created.
SQL> select table_name from user_tables;
TABLE_NAME
--------------------------------------------------------------------------------
RENAME_TABLE
SQL> show user;
USER is "SYS"
SQL> alter table test.RENAME_TABLE rename to test.RENAME_TABLE2;
alter table test.RENAME_TABLE rename to test.RENAME_TABLE2
*
ERROR at line 1:
ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations
问题原因
Oracle是允许A用户修改B用户表名的,但是在新表名前是不能指定用户名的,使用如下方法修改表名成功。
SQL> alter table test.RENAME_TABLE rename to RENAME_TABLE2;
Table altere
SQL> select OWNER,TABLE_NAME from dba_tables where owner='TEST';
OWNER TABLE_NAME
-------------------- --------------------
TEST RENAME_TABLE2
++++++++++++++++++++++++++++++++分割线+++++++++++++++++++++++++++++++
还有一个修改表名的命令rename to ,但是这个命令只能修改自己用户下表的表名
使用Sys用户修改test用户表的表名
SQL> show user;
USER is "SYS"
SQL> select OWNER,TABLE_NAME from dba_tables where owner='TEST';
OWNER TABLE_NAME
-------------------- --------------------
TEST RENAME_TABLE2
SQL> rename test.RENAME_TABLE2 to RENAME_TABLE;
rename test.RENAME_TABLE2 to RENAME_TABLE
*
ERROR at line 1:
ORA-01765: specifying owner's name of the table is not allowed
切换为test用户,修改表名成功
SQL> show user;
USER is "TEST"
SQL> select OWNER,TABLE_NAME from dba_tables where owner='TEST';
OWNER TABLE_NAME
-------------------- --------------------
TEST RENAME_TABLE2
SQL> rename RENAME_TABLE2 to RENAME_TABLE;
Table renamed.
SQL> select OWNER,TABLE_NAME from dba_tables where owner='TEST';
OWNER TABLE_NAME
-------------------- --------------------
TEST RENAME_TABLE
到此,相信大家对“数据库中怎么解决修改表名时遇到ORA-14047错误”有了更深的了解,不妨来实际操作一番吧!这里是亿速云网站,更多相关内容可以进入相关频道进行查询,关注我们,继续学习!
亿速云「云数据库 MySQL」免部署即开即用,比自行安装部署数据库高出1倍以上的性能,双节点冗余防止单节点故障,数据自动定期备份随时恢复。点击查看>>
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。
原文链接:http://blog.itpub.net/2317695/viewspace-2669901/