Re: find all created tables and can't drop table

select owner,table_name from all_tables order by owner, table_name Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"liglin" <liglinlillibli_at_hotmail.com> wrote in message
news:db9bdb31.0301162118.1ad19a0_at_posting.google.com...


> I am trying to create a table in the SQL Plus Worksheet of the Oracle

> Enterprise Manager of 8.1.5. and get:

> ERROR at line 1:

> ORA-00955: name is already used by an existing object

>

> 1. Where can I find a listing of all the tables I have created?

> 2. When I try a DROP  TABLE CALLING_CARD nothing happens

>

> Thanks, Liglin