dbTalk Databases Forums  

dbms_metadata

comp.database.oracle comp.database.oracle


Discuss dbms_metadata in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
SteveC
 
Posts: n/a

Default 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!



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.