Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problems with DBMS_METADATA

Re: Problems with DBMS_METADATA

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 12 Jan 2007 05:02:26 -0800
Message-ID: <1168606946.576633.294200@q2g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US