Re: Dropped table still has name in use David Best wrote:
> "Daniel Morgan" <damorgan@x.washington.edu> wrote in message
> news:1083385412.489365@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%';
>
Well, I hope you didn't do precisely that, because obj$ doesn't actually
have a column called TABLE_NAME. Just NAME will do.
Regards
HJR |