Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Object names changed to BIN$pgkQ... etc

Re: Object names changed to BIN$pgkQ... etc

From: <fitzjarrell_at_cox.net>
Date: Tue, 06 Nov 2007 07:28:52 -0800
Message-ID: <1194362932.551872.326450@o80g2000hse.googlegroups.com>


On Nov 6, 8:21 am, Helma <helma.vi..._at_hotmail.com> wrote:
> Hello all,
>
> I just connected with TOAD 8.6 to a Oracle 10.2.0.1 where i installed
> a database with tables a few days ago. Now when i connect with TOAD,
> most of the tables in the table listing are gone. When i check the
> objects in the tablespaces, toad shows object names like "BIN
> $PgkQhpIOSbrgQAB/AQAKGA==$0". Checking with user_tables gives the
> correct names.
> Any idea how this is happening?
>
> Regards,
> H.

My guess is these tables were recreated and the remnants of the original tables are rummaging about the recyclebin. Since you are also seeing the expected table names it's the only explanation which makes sense.

David Fitzjarrell Received on Tue Nov 06 2007 - 09:28:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US