Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Location
    NYC
    Posts
    3

    Unanswered: Dmp File Import Procedure

    CAN SOMEONE PLEASE GIVE ME A STEP BY STEP PROCEDURE FOR IMPORTING A DMP FILE INTO A FRESH INSTALL OF 8i

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    From the OS level...

    imp username/password@sid --- sid to import into

    Import will ask you questions from here .... fill in the blanks with
    filename, do you want to import data, grants, indexes .... etc ...

    HTH
    Gregg

  3. #3
    Join Date
    Mar 2004
    Location
    NYC
    Posts
    3
    Originally posted by gbrabham
    From the OS level...

    imp username/password@sid --- sid to import into

    Import will ask you questions from here .... fill in the blanks with
    filename, do you want to import data, grants, indexes .... etc ...

    HTH
    Gregg
    tHANKS FOR THE HEADS UP!

    I AM NOW GETTING THE FOLLOWING ERROR MSG:
    SEE THE ATTACHED SCREEN DMP FOR THE EXACT ERROR.

    BASICALLY WHAT I NEED NOW IS THE DEFAULT DBA USER NAME AND PASSWORD . THE ONLY REFERENCE I FIND IS SYSTEM/MANAGER AND SYSMAN/OEN_TEMP. NEITHER SEEMS TO WORK AS A DBA THOUGH!
    Attached Files Attached Files

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    the SYSTEM/MANAGER@sid is all you need. You don't need to use
    "as sysdba" ....

    Gregg

  5. #5
    Join Date
    Mar 2004
    Location
    NYC
    Posts
    3
    Originally posted by gbrabham
    the SYSTEM/MANAGER@sid is all you need. You don't need to use
    "as sysdba" ....

    Gregg
    THANKS!

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Your welcome ...

    Gregg

Posting Permissions

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