dbms_metadata -
04-11-2004
, 09:28 AM
Hello
Is there a way to extract a table's DDL and not have the SCHEMA name part
of the DDL.
I know I can do the following:
dbms_metadata.get_ddl( 'TABLE', table_name ) from user_tables;
But this output gives me the Objects owner as part of the DDL.
I'm looking for:
CREATE TABLE TEST
(COLUMN1 VARCHAR2(10))
....
not
CREATE TABLE OWNER.TEST
(COLUMN1 VACHAR2(10))
....
Thanks for you help! |