how do i Import a .EXP file - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 11 of 11

Thread: how do i Import a .EXP file

  1. #11
    Join Date
    Feb 2014
    Posts
    19
    Installation instructions? We are talking here about import/export.

    Actually the answer is simple:

    THERE IS NO UNCOMPRESS parameter because
    YOU DON'T NEED TO UNCOMPRESS.

    If you use the compress parameter while exporting (whether you use expdp or exp) during import Oracle will recognize itself that the file is compressed during export.

    Only if the file would be zipped then you would have to unzip it.

    In this case the problem lies in the userrights on the disk D:

    MP-00030: failed to create file d:\123.txt for write as the directory where the logfile should be written is not write-accessible for the user who is performing the import. If Oracle can not write the logfile then it stops the import.

    If you try to import a file that is created by using exp and you try to import it by impdp the you will get the error:
    ORA-39000: bad dump file specification.

    You were right about the fact that westcoast43 should check his userrights on the disk or else make sure that he has a disk on which he can write a logfile.
    Last edited by ora_venlo; 08-18-2014 at 09:25 AM.

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