Home > database >  Oracle import the DMP file error message, please help me read the great god
Oracle import the DMP file error message, please help me read the great god

Time:10-18


Connected to the Oracle Database 11 g Enterprise Edition Release 11.2.0.1.0-64 - bit Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options

The Export file created by Export: V10.02.01 via but path
Import the done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Export the client USES WE8ISO8859P1 character set (possible charset conversion)
. Importing SYSTEM 's objects into SYSTEM
IMP - 00017: following the statement failed with ORACLE error 1119:
"CREATE UNDO in TABLESPACE" RBSG_SPC "BLOCKSIZE 8192 DATAFILE '/oradata/P201/d
""Ata/undotbs01. DBF 'SIZE 2048 m among MANAGEMENT, LOCAL
"IMP - 00003: ORACLE error encountered 1119
ORA - 01119: error in creating the database file '/oradata P201/data/undotbs01 DBF'
ORA - 27040: the file create error, unable to create the file
OSD - 04002: unable to open file
O/S - Error: 3 (OS) system could not find the specified path,
IMP - 00017: following the statement failed with ORACLE error 1119:
"CREATE TEMPORARY in TABLESPACE" TEMP_SPC "BLOCKSIZE TEMPFILE as expected '8192/oradata/P"
"201/data/temp01. DBF 'SIZE 1073741824 AUTOEXTEND ON NEXT 655360 MAXSI
""ZE 32767 m among MANAGEMENT, LOCAL UNIFORM SIZE 1048576"
IMP - 00003: ORACLE error encountered 1119
ORA - 01119: error in creating the database file '/oradata P201/data/temp01 DBF'
ORA - 27040: the file create error, unable to create the file
OSD - 04002: unable to open file
O/S - Error: 3 (OS) system could not find the specified path,
IMP - 00017: following the statement failed with ORACLE error 1119:
"CREATE in TABLESPACE DATA_SPC BLOCKSIZE 8192 DATAFILE '/oradata/P201/data/u"
"Sers01. DBF 'SIZE is 2048 m,'/oradata P201/data/users02 DBF 'SIZE is 2048 m"
", "/oradata P201/data/users03 DBF 'SIZE is 2048 m,'/oradata P201/dat"
"A/users04. DBF 'SIZE 2048 m among MANAGEMENT, LOCAL AUTOALLOCATE ONLI
""NE PERMANENT SEGMENT SPACE MANAGEMENT, AUTO"
IMP - 00003: ORACLE error encountered 1119
ORA - 01119: error in creating the database file '/oradata P201/data/users01 DBF'
ORA - 27040: the file create error, unable to create the file
OSD - 04002: unable to open file
O/S - Error: 3 (OS) system could not find the specified path,
IMP - 00017: following the statement failed with ORACLE error 1119:
"CREATE in TABLESPACE INDX_SPC BLOCKSIZE 8192 DATAFILE '/oradata/P201/data/I
""Ndex01. DBF 'SIZE is 2048 m,'/oradata P201/data/index02 DBF 'SIZE is 2048 m"
", "/oradata P201/data/index03 DBF 'SIZE 2048 m among MANAGEMENT L"
"OCAL AUTOALLOCATE ONLINE PERMANENT SEGMENT SPACE MANAGEMENT, AUTO"
IMP - 00003: ORACLE error encountered 1119
ORA - 01119: error in creating the database file '/oradata P201/data/index01 DBF'
ORA - 27040: the file create error, unable to create the file
OSD - 04002: unable to open file
O/S - Error: 3 (OS) system could not find the specified path,
IMP - 00017: following the statement failed with ORACLE error 1119:
"CREATE in TABLESPACE TOOLS_SPC BLOCKSIZE 8192 DATAFILE '/oradata/P201/data/"
"Tools01. DBF 'SIZE 104857600 among MANAGEMENT, LOCAL AUTOALLOCATE ON
""The LINE PERMANENT SEGMENT SPACE MANAGEMENT, AUTO"
IMP - 00003: ORACLE error encountered 1119
ORA - 01119: error in creating the database file '/oradata P201/data/tools01 DBF'
ORA - 27040: the file create error, unable to create the file
OSD - 04002: unable to open file
O/S - Error: 3 (OS) system could not find the specified path,
IMP - 00017: following the statement failed with ORACLE error 959:
"The ALTER USER SYS IDENTIFIED BY VALUES '34032 a6eb9af81f0' TEMPORARY TABLESPA"
"CE" TEMP_SPC "
"IMP - 00003: ORACLE error encountered 959
ORA - 00959: in tablespace 'TEMP_SPC' does not exist
IMP - 00017: following the statement failed with ORACLE error 959:
"The ALTER USER SYSTEM IDENTIFIED BY VALUES '6 eb432a935a0d818' TEMPORARY TABLE"
"SPACE" TEMP_SPC ""
IMP - 00003: ORACLE error encountered 959
ORA - 00959: in tablespace 'TEMP_SPC' does not exist
IMP - 00017: following the statement failed with ORACLE error 959:
"CREATE USER" TSMSYS "IDENTIFIED BY VALUES '3 df26a8b17d0f29f' TEMPORARY TABL"
"ESPACE TEMP_SPC PASSWORD EXPIRE ACCOUNT LOCK"
IMP - 00003: ORACLE error encountered 959
ORA - 00959: in tablespace 'TEMP_SPC' does not exist
IMP - 00017: following the statement failed with ORACLE error 959:
"CREATE USER" DBUSRPOS "IDENTIFIED BY VALUES '3244 ccdf3ec51372' DEFAULT TABL"
"ESPACE DATA_SPC TEMPORARY in TABLESPACE TEMP_SPC" ""
IMP - 00003: ORACLE error encountered 959
ORA - 00959: in tablespace 'DATA_SPC' does not exist
IMP - 00017: following the statement failed with ORACLE error 959:
"CREATE USER" FTPOSERP "IDENTIFIED BY VALUES '19 fbbb1ddd7819f1' DEFAULT TABL"
"ESPACE DATA_SPC TEMPORARY in TABLESPACE TEMP_SPC" ""
IMP - 00003: ORACLE error encountered 959
ORA - 00959: in tablespace 'DATA_SPC' does not exist
IMP - 00017: following the statement failed with ORACLE error 959:
"CREATE USER" FTERPAPP "IDENTIFIED BY VALUES '36 a05437e3347110' DEFAULT TABL"
"ESPACE DATA_SPC TEMPORARY in TABLESPACE TEMP_SPC" ""
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related