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

Home -> Community -> Usenet -> c.d.o.server -> Re: Bad table

Re: Bad table

From: Em Pradhan <empradhan_at_dplus.net>
Date: Wed, 25 Nov 1998 23:37:06 -0500
Message-ID: <365CDAF2.AB2AAE01@dplus.net>


Hi
since you are getting object does not exist ,, take a peek into a view all_objects or dba_objects if the object exists ... then list table from all_tables view make sure that your table name is not case sensitive.

if you don't see your object on any of those then I would say you lost that object.

hope it works...

Happy Thanksgiving...

Gocha Mchedlishvili wrote:

> I have a table with bad data block in it. I don't want to delete this
> table for now, but I would like to rename it , but I'm getting message like
> 'object doesn't exist'. Is there any way I can rename the table?
>
> Thanks
>
> Gocha
Received on Wed Nov 25 1998 - 22:37:06 CST

Original text of this message

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