修改表名的操作 錯誤文法如下: [email protected]> 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
正确文法:
[email protected]> rename mxmtest to mxm;
Table renamed.
結論:在修改表名時,指定表的所有者的名稱是不允許的