| Extract the DDL SQL scripts of the objects in BULK [message #439811] |
Tue, 19 January 2010 09:14  |
shabir46
Messages: 41
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 #440344 is a reply to message #439811] |
Fri, 22 January 2010 13:38  |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
