Re: rename table - insufficient privilege (ORA-01031)

Yes, another poster already pointed this out to me, and I implemented the fix.

Still, the restriction on "rename" command does not seem logical, as ALTER TABLE ... RENAME does the job even from under a different user. But, coming from Sybase/SQL Server background, I find the whole approach of equating a user ID with schema illogical, so this restriction should not be a surprise.

Thank you very much for your help.

Best regards,

Alex.

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:2687bb95.0403140744.2466a65_at_posting.google.com...
> Alex, from the 9.2 Admin manual "To rename an object, it must be in
> your schema." I do not think just switching your effective schema is
> good enough. If would appear you have to be the owner. There is an
> alter table rename to clause that you should be able to use to
> accomplish the same task.
>
> HTH -- Mark D Powell --
Received on Mon Mar 15 2004 - 22:49:19 CET