Re: Dropped table still has name in use

From: David Best <davebest_at_usa.net>
Date: Fri, 30 Apr 2004 23:48:09 -0700
Message-ID: <SJmdnbouWKqw1Q7dRVn-hQ@speakeasy.net>

"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