修改表名的操作
错误语法如下:
ETL@RACTEST> rename etl.mxmtest to etl.mxm;
rename etl.mxmtest to etl.mxm
*
ERROR at line 1:
ORA-01765: specifying table's owner name is not allowed
rename etl.mxmtest to etl.mxm
*
ERROR at line 1:
ORA-01765: specifying table's owner name is not allowed
正确语法:
ETL@RACTEST> rename mxmtest to mxm;
Table renamed.
结论:在修改表名时,指定表的所有者的名称是不允许的