DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import of Multifile export in Oracle 8i

Threaded 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

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