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

Thanks Jim and Daniel for your helpful comments. Yes, you are right Daniel, it was Calling_Card1...

Liglin

DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E27A4F2.4FE6FE02_at_exesolutions.com>...
> liglin wrote:
>
> > 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
>
> Jim's correct with respect to how to tell what tables you have created.
>
> But the fact that you can't drop it makes me think that it may not be a
> table.
>
> Try this too:
>
> SELECT owner, object_type
> FROM all_objects
> WHERE object_name = 'CALLING_CARD';
>
> I'm betting on a synonym.
>
> Daniel Morgan
Received on Mon Jan 20 2003 - 01:02:13 CST