RE: alter table rename error

From: SRIDHARAN, SAN (SBCSI) <ss4569_at_sbc.com>
Date: Thu, 15 Jan 2004 13:19:41 -0800
Message-ID: <F001.005DCF1E.20040115131941@fatcity.com>

Message

Rewrite the query without specifying the owner name and it works.

Alter table emp to employee;

-----Original Message-----
From: eric king [mailto:erickingus@hotmail.com]
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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: SRIDHARAN, SAN (SBCSI)
  INET: ss4569_at_sbc.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:41 CST