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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Recover db on standby server
Next Topic: backup failed
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 17:35:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.