restore a database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: restore a database

  1. #1
    Join Date
    Jun 2006
    Posts
    51

    restore a database

    I have full export file of student_full_db.dmp db. I need steps to restore the db in unix aix environment.

    Thanks for your assistance

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    with the imp command imp help=y will tell you what to do

  3. #3
    Join Date
    Jun 2006
    Posts
    51
    Hi Dave,

    Thanks for your quick response. I'm looking steps to create a new database called studentnew from this dump export file. I would appreciate if you can tell stetps to do it.

    Thanks once again

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    if you need to create a new database, use dbca to do that

    you cant create a database from an export file

  5. #5
    Join Date
    Jun 2006
    Posts
    51
    Thanks once again Dave. I'm using oracle9i so Dbca can used in this version?

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    yep

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width