How to take backup of database in oracle sql developer?

Question

_{Monday, September 3, 2012 6:21 AM}

Hi all,

Hope doing well,

sir i was using my sql database for my application the same database i want in oracle so for that i installed oracle 11g and i have done migration successfully.

now i want how to take back up and restore database in oracle sql developer so that i can use this database to my application.

please help me.

it's urgent

waiting for reply.

thanks in advance.

All replies (4)

_{Wednesday, September 5, 2012 8:17 AM ✅Answered}

Hi Vicky1,

use EXP for backup and IMP for restore . This is command which run in command prompt.

For exp command press "windows+r" , type "EXP", it show command line window. just give username : username@tnsentry, password: yourpassword ,give the output file name with path, then enter and only enter press. after all execution complete it gives backup file .dmp extension.

For restoration or IMP : press "windows+r" , type "IMP", it show command line window. just give username : username@tnsentry, password: yourpassword ,give the restore file name with path, then enter and only enter press. after all execution complete it gives backup file .dmp extension.

see more .

http://docs.oracle.com/cd/B10501_01/server.920/a96652/ch01.htm

http://www.adp-gmbh.ch/ora/admin/imp_exp.html

_{Monday, September 3, 2012 10:53 AM}

You can find solution for your query from following URL :

Oracle Database

In this Oracle Database, 'Migrating Third-Party Databases' topic should help you.

_{Tuesday, September 4, 2012 5:29 AM}

Hi sir,

i checked this link there migration is showing but how to take back up of database and how to restore database and how to save connection from sql developer it's not there.

please help me in that.

thanks for response

_{Tuesday, September 4, 2012 10:09 AM}

http://docs.oracle.com/cd/B28359_01/server.111/b28277.pdf