Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Object names changed to BIN$pgkQ... etc
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