View Single Post

   
  #7 (permalink)  
Old 02-23-2008, 09:14 AM
Howard J. Rogers
 
Posts: n/a
Default 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
Reply With Quote