|
|
Re: Dump objects in SQL form [message #19749 is a reply to message #19724] |
Fri, 05 April 2002 10:55 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
I don't want to push a tool, but personally I'd use TOAD for that. You can extract the basic DDL from the export file using something like this:
imp user/pass@db file=filename.dmp indexfile=ddl.sql show=y
Your basic DDL is in ddl.sql (not everything though)
Extract all DDL and code on Unix using this as a starting point:
strings export_file.dmp > starting_point_ddl.sql
|
|
|