Import of Multifile export in Oracle 8i
Dear All:
I am doing this for the first time.
I got the export backup of one database in multifile export.
I want to impot it in unix. I am doing following
Created a new database with all the tablespaces in exported databazxe.
mknod import_pipe p
chmod 666 import_pipe
nohup cat xaa xab xac xad xae xaf xag xah xai xaj xak xal > import_pipe &
imp userid=system/XXXX file=import_pipe Full=y ignore=yes log=/home/oracle/XXXX_import.log
It imports only the schemas which has nothing in them.
I am getting following errors.
"ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'ACXXXXXXXXX72E' TEMPORARY TABLE"
"SPACE "TEMP_LMT""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TEMP_LMT' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "ORACLE" IDENTIFIED EXTERNALLY DEFAULT TABLESPACE "XXXXXXXXX" TEMPO"
"RARY TABLESPACE "TEMP_LMT""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TEMP_LMT' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "OEM" IDENTIFIED BY VALUES '9XXXXXXXXX65' DEFAULT TABLESPAC"
"E "USERS" TEMPORARY TABLESPACE "TEMP_LMT""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TEMP_LMT' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "BDW" IDENTIFIED BY VALUES '71XXXXXXXXXB0' DEFAULT TABLESPAC"
"E "USERS" TEMPORARY TABLESPACE "TEMP_LMT""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TEMP_LMT' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "BDR" IDENTIFIED BY VALUES 'BEXXXXXXXXX61' DEFAULT TABLESPAC"
"E "USERS" TEMPORARY TABLESPACE "TEMP_LMT""
.......................................................
.......................................................
. importing ORACLE's objects into ORACLE
IMP-00017: following statement failed with ORACLE error 1435:
"ALTER SCHEMA = "ORACLE""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
. importing ORACLE's objects into ORACLE
IMP-00017: following statement failed with ORACLE error 1435:
"ALTER SCHEMA = "ORACLE""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
. importing ORACLE's objects into ORACLE
IMP-00017: following statement failed with ORACLE error 1435:
"ALTER SCHEMA = "ORACLE""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
. importing ORACLE's objects into ORACLE
After research I found that I need to import each user separatly as I dont have os path same. So I gave following commands after stoping and removing previous export command.
mknod import_pipe p
chmod 666 import_pipe
nohup cat xaa xab xac xad xae xaf xag xah xai xaj xak xal > import_pipe &
imp userid=system/XXXX file=import_pipe fromuser=XXXX touser=XXXX ignore=yes log=/home/oracle/pbdw_BDRADMIN_import.log
Still I am facing the following problem.
Export Start and hung at following message.
Export file created by EXPORT:V08.01.07 via conventional path
import done in US7ASCII character set and US7ASCII NCHAR character set
I tryed to find out is there is any activity in the database ther is no activity the session with import is INACTIVE.
CAN any body help me in this. I need help very urgently.
Thanks in ADVANCE
Bhushan