- 论坛徽章:
- 0
|
[oracle@redhat bin]$ ./imp system/manager@juren file=/tools/sql/0530_10.dmp
Import: Release 10.2.0.1.0 - Production on 星期三 5月 30 10:34:14 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.00.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
IMP-00000: Import terminated unsuccessfully
------------------------------------------------------------------------------------------------------------
如果加上 full=y 就会出现这样的问题
----------------------------------------------------------------------------------------------------------
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE UNDO TABLESPACE "UNDOTBS" BLOCKSIZE 4096 DATAFILE 'D:\ORACLE\ORADAT"
"A\JUREN\UNDOTBS01.DBF' SIZE 209715200 AUTOEXTEND ON NEXT 5242880 MAX"
"SIZE 16383M EXTENT MANAGEMENT LOCAL "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "CWMLITE" BLOCKSIZE 4096 DATAFILE 'D:\ORACLE\ORADATA\JUR"
"EN\CWMLITE01.DBF' SIZE 20971520 AUTOEXTEND ON NEXT 655360 MAXSIZE 16"
"383M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "DRSYS" BLOCKSIZE 4096 DATAFILE 'D:\ORACLE\ORADATA\JUREN"
"\DRSYS01.DBF' SIZE 20971520 AUTOEXTEND ON NEXT 655360 MAXSIZE 16383M"
" EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "EXAMPLE" BLOCKSIZE 4096 DATAFILE 'D:\ORACLE\ORADATA\JUR"
"EN\EXAMPLE01.DBF' SIZE 159907840 AUTOEXTEND ON NEXT 655360 MAXSIZE 1"
"6383M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "INDX" BLOCKSIZE 4096 DATAFILE 'D:\ORACLE\ORADATA\JUREN\"
"INDX01.DBF' SIZE 26214400 AUTOEXTEND ON NEXT 1310720 MAXSIZE 16383M "
"EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TEMPORARY TABLESPACE "TEMP" BLOCKSIZE 4096 TEMPFILE 'D:\ORACLE\ORAD"
"ATA\JUREN\TEMP01.DBF' SIZE 41943040 EXTENT MANAGEMENT LOCAL UNIFORM "
"SIZE 1048576"
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "TOOLS" BLOCKSIZE 4096 DATAFILE 'D:\ORACLE\ORADATA\JUREN"
"\TOOLS01.DBF' SIZE 10485760 AUTOEXTEND ON NEXT 327680 MAXSIZE 16383M"
" EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT " |
|