Re: renaming a table

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 07 Mar 2000 02:34:12 GMT
Message-ID: <38c76ac2.18101057@netnews.worldnet.att.net>

Is it possible that indic3 is a synonym, and not a table name? Try the following query:

	SELECT * FROM ALL_SYNONYMS
	WHERE SYNONYM_NAME = 'INDIC3';

DESCRIBE will work with a synonym, but I'm fairly certain that RENAME requires the actual table name.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Mon, 06 Mar 2000 16:50:59 -0800, jbraddock <jbraddockNOjbSPAM_at_sockets.net.invalid> wrote:

>I am trying to use the RENAME statement to rename a table as
>follows: RENAME indic3 TO indic4. Everytime I do this, I get
>an error stating that the object indic3 does not exist, yet I
>can issue a DESC indic3 and it works just fine. According to
>the documentation, RENAME should work with a table. Is there
>something I'm missing here?
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
>The fastest and easiest way to search and participate in Usenet - Free!
Received on Mon Mar 06 2000 - 20:34:12 CST