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:[EMAIL PROTECTED]
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