-
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
-
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.
-
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
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
|