Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bad table
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