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
nghiant
Messages: 38
Registered: July 2006
Location: Viet Nam
Member
Hi all,
I have a database with have more tables and procedures. Can I export it into sql script?
Thanks
NghiaNT
Re: Export database into script [message #253807 is a reply to message #253805] Tue, 24 July 2007 21:19 Go to previous message
ebrian
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: Thu Dec 08 02:27:52 CST 2016

Total time taken to generate the page: 0.16015 seconds