locked
How to take backup of database in oracle sql developer? RRS feed

  • Question

  • User-1965208702 posted

    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.

    Monday, September 3, 2012 6:21 AM

Answers

  • User-578610739 posted

    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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 5, 2012 8:17 AM

All replies

  • User1771049139 posted

    You can find solution for your query from following URL :

    Oracle Database

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

    Monday, September 3, 2012 10:53 AM
  • User-1965208702 posted

    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 5:29 AM
  • Tuesday, September 4, 2012 10:09 AM
  • User-578610739 posted

    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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 5, 2012 8:17 AM