RE: alter table rename error

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 15 Jan 2004 13:19:25 -0800
Message-ID: <F001.005DCF1C.20040115131925@fatcity.com>

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

-----Original Message-----
From: eric king [mailto:erickingus@hotmail.com]
Sent: Thursday, January 15, 2004 3: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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: Mark.Bobak_at_il.proquest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Jan 15 2004 - 15:19:25 CST