-
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!!!
-
Originally Posted by westcoast43
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
-
Originally Posted by LKBrwn_DBA
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.
-
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
-
did you use exp or expdp to export the file? You should make sure that you are using the right utility for the import.
-
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
-
Originally Posted by westcoast43
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
-
So, which parameter is that for uncompressing while importing?
-
Originally Posted by ora_venlo
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|