dbms_metadata.get

From: Naga Challa <nchalla_at_yahoo.com>
Date: 13 Sep 2004 16:38:48 -0700
Message-ID: <79e5986.0409131538.58f844ec@posting.google.com>

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 Received on Mon Sep 13 2004 - 18:38:48 CDT