How to importing with different source/destination schemas

[pheffley]

I have a DMP file that I need to import into my shcema. It was exported from an entirley different database/user. I get the following:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Import file: EXPDAT.DMP > example.dmp

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by AAAA, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no >

Import grants (yes/no): yes >

Import table data (yes/no): yes > yes

Import entire export file (yes/no): no > yes

. importing AAAA's objects into BBBB
. importing CCCC's objects into CCCC
"ALTER SESSION SET CURRENT_SCHEMA= "CCCC""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully

Is there some parameter I should set in order to accomplish this? Please Advise.

Paul

 

[SantaMufasa]

Paul,

If you wish to import schemae into different Oracle usernames from those that exported them, then you must use "command-line" imp instead of "interactive" imp. You must also conduct the imports one source/target pair at a time (since I am not aware that Oracle "imp" supports a "FROMUSER=<multiple-source-users list> TOUSER=<multiple-target-users list>" parameter specification). So, following is a sample command-line version of Oracle imp that should accomplish what you want:

imp buffer=15000000 grants=y feedback=1000 fromuser=AAAA touser=BBBB file=example.dmp log=example_Imp.log  userid=<username>/<password>@<tns alias>

Then, you would do the same type of import for the other source/target pairs that you need from the "example.dmp" dump file.

Let us know the outcome, whether successful or not. We'll be glad to help if "not".

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 17:36 (16Dec04) UTC (aka "GMT" and "Zulu"),
@ 10:36 (16Dec04) Mountain Time