Interesting bug in rename

From: Gregory Conron <gconron_at_hfx.andara.com>
Date: Wed, 21 Feb 2001 20:14:30 -0800
Message-ID: <F001.002BA2B0.20010221175039@fatcity.com>

Came across an interesting bug in the rename command (8.1.6.0.0) (see bug 1359472). Seems if you rename a table, you can drop or truncate it without a problem. However, if you rename a table, then later issue a 'drop user userame cascade;', a bogus entry is placed into the obj$ table, an ora-0600 is returned, and neither the table nor the user can be dropped.

This is rather unfortunate, as rename is a very convenient command.

Cheers,
GC
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gregory Conron
  INET: gconron_at_hfx.andara.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Wed Feb 21 2001 - 22:14:30 CST