Scribd
Upload
657 views

Export DDL DML Oracle SQL Developer

The document provides steps to export DDL and DML scripts from Oracle SQL Developer. For DDL scripts, the steps are to open SQL Developer, select the connection, uncheck options to export only structure, select a file format and path, choose which objects to export, and click finish. For DML scripts, similar steps are followed but the Export DDL option is unchecked and a data format like insert statements is selected.

Uploaded by

Venkat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
657 views

Export DDL DML Oracle SQL Developer

The document provides steps to export DDL and DML scripts from Oracle SQL Developer. For DDL scripts, the steps are to open SQL Developer, select the connection, uncheck options to export only structure, select a file format and path, choose which objects to export, and click finish. For DML scripts, similar steps are followed but the Export DDL option is unchecked and a data format like insert statements is selected.

Uploaded by

Venkat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 11

*Document Only for Learning Purpose

Export DDL & DML Scripts from Oracle SQL Developer


(Documented by using Oracle SQL Developer Version 4.0.1.14)

PART – 1 – Export DDL Scripts

Step 1:

Open  Oracle SQL Developer

Step 2:

Then Click  Tools  Database Export


*Document Only for Learning Purpose
*Document Only for Learning Purpose

Step 3:

Select the Connection (Schema Name From the drop down).

For Export Only - DDL Scripts do the following steps.

 Un check Show Schema Name


 Un check Storage
 Un check the Export Data check Box
*Document Only for Learning Purpose

Step 4:

Select the format you want to save the DDL Scripts

By Click Browse  Select the Path where you want to save your DDL File.

Once you select the Path then Click  Next


*Document Only for Learning Purpose

Step 5:

You will get the below window:

You want specific Object then Unselect All ...then Select the Object’s - you’re going to export: My
Case i have selected only “Tables”

Then Click  Next


*Document Only for Learning Purpose

Step 6:

You’re going to export All the Object then you can directly click  Next in the below Window

You’re going to export the Particular specific object then click the  Lookup...Once you click lookup
all the Objects has been loaded in the window like below format. Then Select the Objects you want
by Click  “>” button
*Document Only for Learning Purpose

Then Click  Next

Step 7:

Then Finally Click  Finish

Your DDL file has been saved successfully...You can get the file from your saved location or
directory...
*Document Only for Learning Purpose

PART – 2 – Export DML Scripts


Most of the Steps which is Similar to DDL

Click  Tools  Database Export ... and do the following steps

Select the Connection (Schema Name) you want to export DML Scripts.

 Uncheck Show Schema


 Uncheck Storage
 Uncheck Export DDL(Its only for DDL scripts)

Select the Export Format you want...Like Insert, Excel, CSV, Pdf....etc...
*Document Only for Learning Purpose

Then click Save As  and select the Format which one you want...

Then Click Browse  and select the Path where you want to save your DML Scripts...
*Document Only for Learning Purpose

Then click  Next

Select the Objects type you want to export...Then click  Next

Same like DDL, In the below window if you want all the table DML then directly click Next...else you
want to export Specific objects then Click  Lookup then select the object and Click Next...Like
below format.
*Document Only for Learning Purpose

Final Step Click  Finish

Your DML file has been saved successfully...You can get the file from your saved location.

You might also like