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
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