Import of Multifile export in Oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import of Multifile export in Oracle 8i

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    50

    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
    Last edited by BHUSHAN; 02-04-2006 at 03:33 PM. Reason: just put some more log

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Did you check you have created all the tablespaces and users in the unix db where you are doing an import?

    Does 'TEMP_LMT' tablespace exists?
    Does user Oracle exists?
    "What is past is PROLOGUE"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width