Re: Problems with DBMS_METADATA

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 Received on Fri Jan 12 2007 - 07:00:41 CST