Results 1 to 5 of 5

Thread: how to import .dmp file into Oracle 9i?

  1. #1
    Join Date
    Jun 2005
    Posts
    28

    how to import .dmp file into Oracle 9i?

    Hi,

    I can't find any information about importing .dmp into Oracle 9i. All the articles i read are about export.
    Could you please provide me detail instruction of importing .dmp file into oracle 9i.

    Thank,s

  2. #2
    Join Date
    Mar 2003
    Posts
    468
    the options to export and import are fairly the same. of course, depending on what you want to do.

    do you know how the export was taken, was it a full export, schema export, or something else. who was the export taken as?

    maybe restate what it is you are trying to do.
    if you are trying to do a full import the command is :
    imp <user>/<password>@<tns> file=your.dmp full=y log=your.log ignore=y

    you can get a list of options by issuing:
    imp help=y

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Import is documented in Utilities book of Oracle documentation.

  4. #4
    Join Date
    Jun 2005
    Posts
    28
    Quote Originally Posted by jkoopmann
    the options to export and import are fairly the same. of course, depending on what you want to do.

    do you know how the export was taken, was it a full export, schema export, or something else. who was the export taken as?

    maybe restate what it is you are trying to do.
    if you are trying to do a full import the command is :
    imp <user>/<password>@<tns> file=your.dmp full=y log=your.log ignore=y

    you can get a list of options by issuing:
    imp help=y

    my customer sent me a dmp file of his database. he was the one export the dmp file.
    i am not sure if he did a full or schema export
    what are the difference?

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Run

    imp file=file.dmp show=y

    This will show you the content of the DMP file

Posting Permissions

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