Title: Message
Eric,
Try:
ALTER
TABLE scott.emp RENAME TO employee;
Mark J.
Bobak Oracle DBA ProQuest Company
Ann Arbor,
MI "Imagination
was given to man to compensate him for what he is not, and a sense of humor was
provided to console him for what he is." --Unknown
You cannot specify a schema in the rename clause. Simply change your
statement to alter table scott.emp rename to employee. The table will
stay within the scott schema even if the command is executed by another
user.
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 PMTo: Multiple recipients of list ORACLE-LSubject:
alter
Title: RE: alter table rename error
Eric,
No schemas allowed. Take out both of the scott. You need to be logged in as Scott to rename Scott's tables.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: eric king [SMTP
ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED]cc:
ott.af.mil Subject: RE: alter table rename error