Re: Oracle generated tables in 10g?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 14 Apr 2004 14:14:08 +0000 (UTC)
Message-ID: <c5jgvg$7gf$1@sparta.btinternet.com>

Look up "recyclebin"
Also

purge recyclebin;
drop table XXX purge;

This is the Oracle equivalent of the
Windows waste basket. As Yogi Berra
would not have said:

It's not dropped until it's purged.

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

April 2004 Iceland  http://www.index.is/oracleday.php
June  2004      UK - Optimising Oracle Seminar


"hastenthunder" <hastenthunder_at_yahoo.com> wrote in message
news:awbfc.128$Ny6.233_at_mencken.net.nih.gov...


> Hi,

>

> I'm running RedHat Adv. Server 3 and recently upgraded Oracle from 9i to

> 10g.

> The database server works fine after the upgrade, but I noticed that it

> auto-generates tables in frequently used schema, with strange names such

as


> BIN$1/a5lQ4QhzrgMIJDBiQ4eA==$0.  These tables are usually an image copy of

> another (real) table in the same schema.

>

> Does anyway know why does Oracle do that, and what can I do to prevent

these


> tables from being generated?

>

> Thanks a lot

>

> hastenthunder

>

>

Received on Wed Apr 14 2004 - 09:14:08 CDT