Supppose, I am logged on to a SYS account and want to rename table SCOTT.TESTTAB to SCOTT.TESTTAB1. If so, I'm getting the following error: ORA-01765: specifying tables owner name is not allowed.
PL/SQL Developer obviously tries to execute command: 'rename SCOTT.TESTTAB to SCOTT.TESTTAB1' instead of: 'alter table SCOTT.TESTTAB rename to TESTTAB1'
PL/SQL Developer obviously tries to execute command: 'rename SCOTT.TESTTAB to SCOTT.TESTTAB1' instead of: 'alter table SCOTT.TESTTAB rename to TESTTAB1'
Last edited:
