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.

Steps:
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.

Done!!

LinkWithin

Related Posts Plugin for WordPress, Blogger...