| Import Problem [message #73127] |
Tue, 10 February 2004 00:59  |
Man Mohan Sharma
Messages: 35
Registered: October 2003
|
Member |
|
|
When going to Import in dump file in AIX, exported from Windows 2000 server the following error has encountered. The DB_BLOCK_SIZE of exported environment is 4096 while DB_BLOCK_SIZE of AIX environment is 8192. Pls. give the soln urgently.
Export is taken using the command:
exp system/manager file=xyz.dmp log=exp1.log full=y
After creating the required Tablesapce from OEM I have tried to import using command
imp system/manager file=xyz.dmp log=imp1.log full=y ignore=y
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V09.00.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8MSWIN1252 character set (possible charset conversion)
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 'F:MMISCMCDRSYS01.DBF"
"' SIZE 88080384 AUTOEXTEND ON NEXT 655360 MAXSIZE 4095M EXTENT MANAG"
"EMENT 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 'F:CMCTEMP1.O"
"RA' SIZE 536870912 , 'F:CMCTEMP2.ORA' SIZE 536870912 EXTENT MA"
"NAGEMENT LOCAL UNIFORM SIZE 10485760"
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 'F:MMISCMCTOOLS01.DBF"
"' SIZE 78643200 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 65536 ONLINE PE"
"RMANENT "
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 "PURCHASE" BLOCKSIZE 4096 DATAFILE 'F:MMISCMCPURCHASE"
"01.DBF' SIZE 262144000 , 'F:MMISCMCPURCHASE02.DBF' SIZE 262144000 "
" , 'F:MMISCMCPURCHASE03.DBF' SIZE 104857600 , 'F:MMISCMCPURCH"
"ASE04.DBF' SIZE 262144000 , 'F:MMISCMCPURCHASE05.DBF' SIZE 31457280"
"0 , 'F:MMISCMCPURCHASE06.DBF' SIZE 262144000 , 'F:MMISCMCPU"
"RCHASE07.DBF' SIZE 209715200 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 26"
"2144 ONLINE PERMANENT "
|
|
|
|
| Re: Import Problem [message #73129 is a reply to message #73127] |
Wed, 11 February 2004 02:34  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
ANY one of the following should solve your problem:
1) Pre-create all your tablespaces on the new databases before importing (easiest solution).
2) Re-create the entire database with a 4 Meg primary block size.
3) Configure your database to also support 4 Meg blocks (I'm sure you do not want to go there!).
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
