RE: alter table rename error

[SRIDHARAN, SAN (SBCSI)]

Title: Message

Rewrite the query without specifying the owner name and it works.   Alter table emp to employee; -----Original Message----- From: eric king [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 12:00 PM To: Multiple recipients of list ORACLE-L Subject: alter table rename error Just try to rename table and get this error, anyone knows what this error is? alter table scott.emp rename to scott.employee ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations   eric