Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bad table
Hi,
Did you spell your table name correctly? Check it in user_tables, especially upper and lower case.
Andrew Protasov
> I tried this, but I'm getting message "object doesn't exist" ...
>
> Thanks
> Gocha
>
> Andrew Protasov wrote in message ...
> >
> >Hi,
> >
> >Try this
> >
> >SVRMGR> rename "LAGA_NESTED1" TO "_LAGA_NESTED1";
> >Statement processed.
> >SVRMGR> rename "_LAGA_NESTED1" TO "LAGA_NESTED1";
> >Statement processed.
> >
> >Andrew Protasov
> >
> >> 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 - 03:18:25 CST