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

Home -> Community -> Usenet -> c.d.o.tools -> Re: cannot see tables

Re: cannot see tables

From: <devnull50_at_yahoo.com>
Date: 3 Jul 2001 14:09:46 GMT
Message-ID: <9hsjna$r6o$1@news.netmar.com>

You might try;

select owner, table_name from all_tables;

Once you know who owns the table, login as that person and drop the tables, or
as SYSTEM type:

drop table owner.table_name;

Hope this helps.

Evan S.

Received on Tue Jul 03 2001 - 09:09:46 CDT

Original text of this message

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