Export Oracle DDL to flat file using sql developer

Open SQL Developer, connect to the database.

Below i connected to SYS user and then go to Other User in left pane. Here i am going to take the DDL of EMP table from SCOTT Schema Expand it and select the table for which you are looking for DDL..

ImageRight click on the table.

Image

Click on Save to File option and select the path for this DDL and your are done.

Image

We are done with the DDL of EMP. 

Thanks !

Hope it helps.

Advertisements

One thought on “Export Oracle DDL to flat file using sql developer

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s