Re: Missing Table?

From: SUVAS LAKSHMIKUTTYAMMA <lsuvas_at_worldnet.att.net>
Date: 6 Aug 1998 06:16:10 GMT
Message-ID: <6qbhna$ski@bgtnsc02.worldnet.att.net>

Possibly you are not connected as the owner of the table that you are trying to drop. If you are not the owner of the table and you want to drop the table you must have "DROP ANY TABLE" privilege.

Also if you are connected as say "system" and you want to drop a table in another schema you have to issue the command
"DROP TABLE OWNER.TABLE_NAME"
where owner is the userid which created the table (This assumes that you do not have a public synonym on the table)

Hope this helps.

Binoy James wrote in message <6pnms5$k5b$1_at_ash.prod.itd.earthlink.net>...
>Folks,
>
>We have a weird situation here. We are trying to get rid of two tables in
>our db. Problem is when we try and delete or do a select on either of
them,
>we get an error message that the table does not exist. However they exist
>in dba_objects and dba_tables.
>
>What's going on?
>Jim
>
>
Received on Thu Aug 06 1998 - 01:16:10 CDT