Re: Dropped table still has name in use

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 01 May 2004 17:39:21 +1000
Message-ID: <40935421$0$4548$afc38c87@news.optusnet.com.au>

David Best wrote:
> "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%';
>

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 Received on Sat May 01 2004 - 02:39:21 CDT