Home » RDBMS Server » Server Utilities » Extract the DDL SQL scripts of the objects in BULK
Extract the DDL SQL scripts of the objects in BULK [message #439811] Tue, 19 January 2010 09:14 Go to next message
shabir46
Messages: 40
Registered: November 2009
Member
Hi,

I have the development database and there are around 300 tables and its corresponding views.

I need to take the backup of the DDL scripts of all the tables manually and keep it within a text file.

Please can you advice if there is specific utility or some methode for doing this other than manually taking the SQL scripts from either Sql developer or TOAD?

Expecting a quick response from someone.

Thanks in advance,
Shabir Kaithayil

Re: Extract the DDL SQL scripts of the objects in BULK [message #439815 is a reply to message #439811] Tue, 19 January 2010 09:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just for DDL of whole schema, exp/expdp would do the job.
Take an export without data.
There is a more flexible option (and more work). Use
DBMS_METADATA.
There are many examples in this forum . Please Search orafaq/google.
icon12.gif  Re: Extract the DDL SQL scripts of the objects in BULK [message #440344 is a reply to message #439811] Fri, 22 January 2010 13:38 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Apart from the DBMS_METADATA package you could also do:

1) SQL Developer will generate a file with the DDL: Tools -> Database export -- You get an export wizard where you can export DDL and/or data.

2) TOAD has also the ability to generate a file with the DDL for any schema (no need to copy and paste).

3) Take export without data and use DDL Wizard to get DDL.

[EDITED by LF: fixed [url] tags]

[Updated on: Fri, 22 January 2010 23:50] by Moderator

Report message to a moderator

Previous Topic: Full Import
Next Topic: Where to find scheduled jobs (dbms_scheduler)
Goto Forum:
  


Current Time: Sat Dec 03 12:28:19 CST 2016

Total time taken to generate the page: 0.15663 seconds