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 !!
No comments:
Post a Comment