GENERATE DDL to a FILE 1

[jestrada101]

what would be the best method to do this? I want to generate DDL to a file on the OS.

 

[LKBrwnDBA]

1) Use combination of DBMS_METADATA and UTL_FILE utilities.
2) Export with options rows=n owner=MySchema, download DDL Wizard and generate the code!



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[jestrada101]

Thanks! I think UTL_FILE is what I was looking for. I'll play around with that!

JE

 

[jestrada101]

UTL_FILE requires that I set a parameter in init.ora, is there a way I can use CREATE DIRECTORY without having to change anything in init.ora?

 

[LKBrwnDBA]

Yes, depending on Oracle version (8.1.7 and above)


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb