Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: error message: table or view existed when creating a table
try:
select * from user_objects
where object_name='XYZ'
and see what it responds.
<dbajjer_at_my-deja.com> wrote in message news:8m2epr$pkj$1_at_nnrp1.deja.com...
> I was trying to create a table in a Oracle DB with the following
> statement:
>
> create table XYZ;
>
> and I got a error message: table or view existed.
>
> Then I tried to drop this XYZ table, and got another error message:
> table or view not found.
>
> Can anyone tell me what is wrong and why this would happen?
>
> Thanks
>
> dbajjer
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jul 31 2000 - 00:00:00 CDT