Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dropped table still has name in use
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1083385412.489365_at_yasure...
>
> Just on a chance ... try this:
>
> SELECT owner, table_name
> FROM dba_tables
> WHERE LOWER(TABLE_NAME) LIKE '%utl_tables%';
>
Nope, no data found. I also tried:
SELECT *
FROM sys.obj$
WHERE LOWER(TABLE_NAME) LIKE '%utl_tables%';
on the off chance that maybe the dictionary has been corrupted (I don't know if that's possible), but still nothing. But the name must exist somewhere! If it is a dictionary corruption issue, where could I find some info to dig into this?
Thanks,
Dave
Received on Sat May 01 2004 - 01:48:09 CDT
![]() |
![]() |