Friday, March 15, 2013

How to copy Oracle database with Oracle SQL Developer

This is another option to back up / clone an existing Oracle database to another database.
and the advantage of this option is, Administrator right is not required for the user who performing the copy option.

1. Start Oracle SQL Developer
2. Tools > Database Copy... > New Copy Wizard
Oracle SQL Developer - copy wizard

3. Select Source Connection and Destination Connection, Next
4. Review the action to be performed.
Oracle SQL Developer - copy wizard
5. Click Finish and wait the action to complete.



Related Posts Plugin for WordPress, Blogger...