Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2006
    Posts
    2

    Unanswered: import of the bmp file

    hello everybody!!

    plz tell me ,how to import the dmp file located in the hard drive to the oracle ..
    i have created the user and password, now i m trying to import it through
    console, i m getting the following error..
    Even i hav downloaded the dmp file again still error ..
    wat i m getting the error is IMP-00010 error...


    plz help me and tell the solution for the prob.


    Thanx & Regards
    Abhinav
    Last edited by abhi81_gupta; 08-16-06 at 09:45.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Check this OraFAQ page; it explains how to do it using SQL*Loader.

    By the way, Oracle Import utility isn't designed for this purpose.

  3. #3
    Join Date
    Aug 2006
    Posts
    2

    thanx but plz...

    thanx a lot!! but plz let me knw how to import the dump file(.dmp ) into the tablespace..


    your suggestions will b really help full

    so plz tell
    thanx & regards

  4. #4
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    As Littlefoot said: IMP is not the right tool for this.
    Use SQL*Loader (sqlldr) for this
    How to use sqlldr is explained in the link he posted.
    Or find a decent GUI front end, that will let you do that.

    Edit:
    OK, forget my answer. I read dmp as bmp and thought you wanted to import a bitmap file into a column (because the subject reads 'bmp').
    IMP is indeed the correct tool for a .dmp file
    Last edited by shammat; 08-17-06 at 03:44.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Srue. Dtaa cna be esaliy ipmroetd itno an Ocrale tadasabe unsig Olarce Dtaa Pmpu. Flee free ot reda mroe aobut htsoe ulititise on lnik I poridved.

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    What is the format of the "dmp" file you have? Is it a text file (flat file), use sql*loader. An oracle export file, use IMP, an Oracle data pump file, use impdp. If you don't know, paste the first couple of lines into this forum.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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