DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: how do i Import a .EXP file

  1. #1
    Join Date
    Aug 2014
    Location
    SoCal
    Posts
    3

    how do i Import a .EXP file

    hello all!!

    I am following the "Oracle® Utilities Work and Asset Management Installation Guide for Windows Platform Release 1.9.1.1 E39489-03"

    http://docs.oracle.com/cd/E39491_04/...on_windows.pdf

    I have created a Database named “test01”, I am at the step to import an .EXP file, not a DMP.

    I have tried this command a few different ways, I have also moved the EXP and renamed it to make the path shorter…
    SQL> host imp file=d:\1911.exp full=yes log=d:\123.txt
    Import: Release 11.2.0.1.0 - Production on Sat Aug 2 16:49:46 2014
    Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
    IMP-00030: failed to create file d:\123.txt for write
    IMP-00000: Import terminated unsuccessfully
    SQL>


    any help would be great!

    thx!!!

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    Quote Originally Posted by westcoast43 View Post
    hello all!!

    I am following . . .
    . . ., I am at the step to import an .EXP file, not a DMP.

    I have tried this command a few different ways, I have also moved the EXP and renamed it to make the path shorter…
    SQL> host imp file=d:\1911.exp full=yes log=d:\123.txt
    Import: Release 11.2.0.1.0 - Production on Sat Aug 2 16:49:46 2014
    Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
    IMP-00030: failed to create file d:\123.txt for write
    IMP-00000: Import terminated unsuccessfully
    . . .
    1) The error indicates you may not have privileges to create the log file on disk D:
    2) Which would be the step you are referring to?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Aug 2014
    Location
    SoCal
    Posts
    3
    Quote Originally Posted by LKBrwn_DBA View Post
    1) The error indicates you may not have privileges to create the log file on disk D:
    2) Which would be the step you are referring to?
    Thx for the reply!! I am at this step

    1.1.5 Do a full import of the wamnew1911 or wamsmp1911 database, depending on
    your requirements. The file must be uncompressed first.
    Wamsmp1911 contains an Oracle Work and Asset Management database
    export with sample data. Wamnew1911 is essentially an empty database with no
    sample data.

    D:\synergen\test\server\server1911\wamnew1911\wamnew1911.exp

    is the file that I need to import.

    I renamed it to 1911.exp on the root of the d drive just to shorted the path.

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    Do a full import of the wamnew1911 or wamsmp1911 database, depending on
    your requirements. The file must be uncompressed first
    1) Make sure you have permission to create files on disk D.

    2) Before import you need to un-compress it.

    Last edited by LKBrwn_DBA; 08-05-2014 at 12:41 PM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    did you use exp or expdp to export the file? You should make sure that you are using the right utility for the import.

  6. #6
    Join Date
    Aug 2014
    Location
    SoCal
    Posts
    3
    The issues seems to be its a EXP not DMP file.

    I have followed this is SQLPLUS

    create directory expdp_dir as 'c:\temp'; <- directory where wamsmp1911.EXP file exists
    grant read,write on directory expdp_dir to username;

    All completes ok

    then I go to CMD (windows 2008R2 64 bit)
    I have tried all these.... username/password@database = scott/tiger@orcl
    imp username/password@database DIRECTORYY=expdp_dir DUMPFILE=wamsmp1911.exp FULL=YES
    impdp username/password@database DIRECTORYY=expdp_dir DUMPFILE=wamsmp1911.exp FULL=YES

    I get Bad dump file. Which I understand my wamsmp1911.exp isnt a DMP file.

    I am getting the file friom oracle, but I can not find a way to import a .EXP file

  7. #7
    Join Date
    Feb 2014
    Posts
    22
    1.Why did you try to start an import on SQL? Are you not allowed to go on the OS prompt?

    2. Where did you get the file from? Did you create the export file yourself or someone gave it to you? If you get it from someone else then you maybe can ask what he used....expdp or exp.

    3. From what I see from the first message it is very obvious that you are not allowed to create a file on D:\. Maybe you should try to create in c:\temp or, if you have access to a disk create your own diricetory under which you can create a logfile.

  8. #8
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492
    Quote Originally Posted by westcoast43 View Post
    The issues seems to be its a EXP not DMP file.
    . . . E t c
    I get Bad dump file. Which I understand my wamsmp1911.exp isnt a DMP file.

    I am getting the file from oracle, but I can not find a way to import a .EXP file
    As stated in the install document, you need to first un-compress the file:

    1.1.5 Do a full import of the wamnew1911 or wamsmp1911 database, depending on
    your requirements. The file must be uncompressed first.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  9. #9
    Join Date
    Feb 2014
    Posts
    22
    So, which parameter is that for uncompressing while importing?

  10. #10
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Thumbs down

    Quote Originally Posted by ora_venlo View Post
    So, which parameter is that for uncompressing while importing?
    Perhaps you need to read the installation instructions to find out.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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