Re: Dropped table still has name in use

From: David Best <davebest_at_usa.net>
Date: Sat, 1 May 2004 00:57:35 -0700
Message-ID: <85WdnVQa-7_uxQ7dRVn-jA@speakeasy.net>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:40935421$0$4548$afc38c87_at_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
doh, you're right...I copied/edited your lines rather than paste from sqlplus because I accidentally closed the dos window too soon, my bad. But yes, I did the correct query and got no data found.

Dave Received on Sat May 01 2004 - 02:57:35 CDT