 Unable to import .DMP file. [message #200997] |
Thu, 02 November 2006 03:29  |
grahambo
Messages: 9
Registered: November 2006
|
Junior Member |
|
|
Hi
I wonder if anybody can help me. I created a *.dmp file from a database using the 'exp' untility.
the dump is of the entire database being exported. I now have created a new database with a different SID and am trying to import the file (I basically am testing that this way of backing up our DB actually works, i will be deleting this test Restore DB as soon as the import of the dump file is completed).
However I have encountered a problem when I try to import. It does not import the users correctly and is throwing up and error.
////////////Here is how I export the dump file
D:\oracle\ora92\rdbms\admin>exp
Export: Release 9.2.0.6.0 - Production on Thu Nov 2 09:22:09 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: sys as sysdba
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP > C:\mydump.dmp
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > E
Export grants (yes/no): yes > yes
Export table data (yes/no): yes > yes
Compress extents (yes/no): yes > yes
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P15 character set (possible charset conversion)
//////////// And here is how I attempt to import the dump file
D:\oracle\ora92\rdbms\admin>set Oracle_SID=test
D:\oracle\ora92\rdbms\admin>imp
Import: Release 9.2.0.6.0 - Production on Thu Nov 2 09:28:51 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: sys as sysdba
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Import file: EXPDAT.DMP > C:\mydump.dmp
Enter insert buffer size (minimum is 8192) 30720>
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P15 character set (possible charset conversion)
List contents of import file only (yes/no): no > no
Ignore create error due to object existence (yes/no): no > no
Import grants (yes/no): yes > yes
Import table data (yes/no): yes > yes
Import entire export file (yes/no): no > yes
And Here is the Error I am getting!
"ALTER SESSION SET CURRENT_SCHEMA= "RR_OWNER""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully
Can anyone help, My knowledge of oracle is very very limited. If you have a solution can you please explain it very clearly thanks
Graham
|
|
|
|
|
|
|
|
| Re: Unable to import .DMP file. [message #201491 is a reply to message #201484] |
Sat, 04 November 2006 16:23  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
I stated:
>> If you are import into another database then the physical
>> location of datafiles may change and so tablespace creation and user creation may fail.
What i actually meant is
By default the full database import will try to recreate the datafiles in the same location ( as found
in exported dump). If the directory structure is different in the target machine eventually tablespace creation
and user creation will fail.
I apologize for using sloppy description i did earlier and many thanks to Kim for pointing it out.
Apparently, i should stop posting any lackadaisical responses by the wee hours. 
>>Re: Unable to import .DMP file. [message #201010 is a reply to message #200997 ] Thu, 02 November 2006 05:17
Kim wrote:
>>Mahesh - do not take this as an insult,
Nope. Never. Healthy criticism will bring better results and help to fine tune the skills.
So i actually owe you one here
http://www.orafaq.com/forum/t/65804/42800/
[Updated on: Sat, 04 November 2006 16:41] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
