Home » SQL & PL/SQL » SQL & PL/SQL » Dump objects in SQL form
Dump objects in SQL form [message #19724] Thu, 04 April 2002 19:59 Go to next message
Sergey Potapov
Messages: 1
Registered: April 2002
Junior Member
Hi, is anyone knows, how to get dump of existing schema objects _as sql script_? It's very usefull for create install script.
Re: Dump objects in SQL form [message #19743 is a reply to message #19724] Fri, 05 April 2002 05:59 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
http://www.databee.com/

Free tool that uses an export of your DB with ROWS=N and then creates all the DDL for you.
Re: Dump objects in SQL form [message #19749 is a reply to message #19724] Fri, 05 April 2002 10:55 Go to previous message
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
Previous Topic: Re: sql help for(3 condition st)
Next Topic: getting error oracle8.1.6
Goto Forum:
  


Current Time: Mon Mar 18 22:36:50 CDT 2024