Re: Drop table with garbled tablename

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Fri, 02 Jul 2004 19:39:56 +0100
Message-ID: <jpabe059jc20hjjufbetfmgotivbi2peik@4ax.com>

On 2 Jul 2004 11:18:56 -0700, aj70000_at_hotmail.com (AJ) wrote:

>How can I drop a table with garbled tablename? This was created while
>doing datamigration.
>
>Drop table BIN$3fBXWrrtbVbgMAEKFgQSrw==$0 (name of the table)

Look up 'Recycle Bin' in the 10g documentation, and the PURGE command.

Or if it's not actually a recycle binned object and instead got copied across from another 10g instance, put double quotes around the name.

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space

Received on Fri Jul 02 2004 - 13:39:56 CDT