Re: dbms_metadata.get_ddl

Naga Challa wrote:

> Hi,
> We have two schemas s1 and s2 in an oracle database instance.
> We access the table t1 of schema s1 through public synonym from
> schema s2.
> Is there any way for me to get the ddl of table t1 of schema s2 from
> schema s1. If yes, what is the synatax?
> I tried to use dbms_metadata.get_ddl('TABLE', 'T1', 'S1') and
> dbms_metadata.get_ddl('TABLE', 'T1, 'S2'). It says table doesn't exist
> in the schema I specified.
>
> Thanks in advance.
>
> Naga Challa

grant appropriate object privileges: Then schema_name.object_name

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)