Tuesday, July 10, 2012

DataBase Export using Jdeveloper


I have been using Jdeveloper for years now and still was not aware of this cool utility.
Most of the time we need to take backup of our custom Schema/Database , Jdeveloper provides a very simple tool to do this.

Steps:

1. Tools | Database Export

2. Choose the connection and File location for the SQL script for export



3. Choose the object types you want to export



4. Select the Objects , it lists all the eligible objects (Tables , Sequences,constraints ,etc )


5. Specify the data, yes you got it right it exports table data as well


6. Validate summary and Finish

That's it , you will get a SQL script properly commented with DDL and DML for all the objects.

Its cool !!