SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question about ORA-26563: renaming this table is not allowed

bencolNov 4 2010 — edited Jan 23 2013

I tried

RENAME a TO b;

And got error ORA-26563

I checked all_dependencies where referenced_name = 'A' and there where only packages and views referencing A.
I checked all_mview_logs where master = 'A' and no rows were returned.

I ran

exec dbms_mview.begin_table_reorganization(user,'A')

And the rename then worked, but I don't understand why. I've fixed the problem, but don't feel satisfied.

Can anyone shed any light on this please?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2013

Added on Nov 4 2010

4 comments

11,297 views