[20190427]表改名与ora-14047错误.txt

[20190427]表改名与ora-14047错误.txt --//改表名失败,做一个记录: 1.环境: SCOTT@book> @ ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production create table t as select rownum id from dual ; create unique index pk_t on t(id); SCOTT@book> alter table scott.t rename to scott.ttx; alter table scott.t rename to scott.ttx                                    * ERROR at line 1: ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations --//这个报错很奇怪,什么是其它操作...注意*号出现位置. --//想一下，表改名oracle目前不会支持修改schema模式的.修改如下ok： SCOTT@book> alter table scott.t rename to ttx; Table altered. --或者 SCOTT@book> alter table ttx rename to tty; Table altered. --//实际上遇到这类问题，使用toad + sql_track操作跟踪看看就知道了，不过好像toad执行如下： SCOTT@book> rename  tty to ttz; Table renamed. SCOTT@book> rename   ttz to scott.tta; rename   ttz to scott.tta                      * ERROR at line 1: ORA-01765: specifying owner's name of the table is not allowed $ oerr ora 01765 01765, 00000, "specifying owner's name of the table is not allowed" // *Cause: An attempt was made to rename the object with dotted object name. // *Action: Do not specify username.tablename  in query for table name. --//这个提示就很清晰!!实际上手边有一份oracle sql参考手册函数很有必要的.