Home » RDBMS Server » Backup & Recovery » Export database into script
Export database into script [message #253805] Tue, 24 July 2007 21:13 Go to next message
Messages: 38
Registered: July 2006
Location: Viet Nam
Hi all,
I have a database with have more tables and procedures. Can I export it into sql script?
Re: Export database into script [message #253807 is a reply to message #253805] Tue, 24 July 2007 21:19 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
What version of Oracle?

If you want just the DDL, you can consider DBMS_METADATA, or if you are on 10g, you can use expdp with CONTENT=METADATA_ONLY parameter if you'll be importing elsewhere.
Previous Topic: Recover db on standby server
Next Topic: backup failed
Goto Forum:

Current Time: Fri Jul 21 20:18:03 CDT 2017

Total time taken to generate the page: 0.23744 seconds