Results 1 to 5 of 5

Thread: Cannot IMP DATABASE????

  1. #1
    Join Date
    Sep 2005
    Posts
    4

    Post Cannot IMP DATABASE????

    VERDANA

    This is my errors... pls help me....I cannot import database table..why it is happened??

    IMP-00002:failed to open expdat.dmp for read
    Import File:EXPDAT.DMP>


    Thank you,,


    *Nobody knows the answer???? Why????
    Last edited by joniemania; 09-29-2005 at 11:36 PM.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Post your import command. Sounds like you have not specified the correct export file.

  3. #3
    Join Date
    Sep 2005
    Posts
    4
    Hi,

    I specified the correct export command..it's like this

    exp system/password file=myexp.dmp full=y log=myexp.log

    i can make export file but when its come to import this file having trouble...

    Always this error I get:
    IMP-00002:failed to open expdat.dmp for read
    Import File:EXPDAT.DMP>

    Pls tell me why this is happening???

    Thank you for your reply....

    @};-

  4. #4
    Join Date
    Oct 2005
    Posts
    2

    Talking solution to imp failure

    try this...

    imp system/password file=myexp.dmp full=y log=myimp.log ignore=yes

  5. #5
    Join Date
    Jan 2010
    Posts
    2

    Wink hi

    actually u have to specify the exp file which u had taken already

    for ex:
    $imp scott/tiger file=<"ur exported file">.dmp full=y log=<filename>.log

    Thanks
    kp

Posting Permissions

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