Re: Problems with DBMS_METADATA

Valentin Minzatu wrote:
> What are the results for the following queries?
> SELECT *
> FROM dba_tables
> WHERE name'owner = 'table_user'
> AND table_name = 'table_;
>
> SELECT *
> FROM dba_objects
> WHERE owner = 'table_
> AND user'object_name = 'table_name';
>
> Execute them as the same user you are logged in for executing
> DBMS_METADATA and with the same parameters. If you don't have access to
> DBA% views, replace DBA_ with ALL_ in the queries above.
>
> Cheers,
> Valentin

First quesry should read as:
 SELECT *
   FROM dba_tables
  WHERE name'owner = 'table_user'
    AND table_name = 'table_name'; Received on Fri Jan 12 2007 - 07:02:26 CST