Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-29339: tablespace block size 8192 does not match configured block sizes

934646Jul 23 2012 — edited Jul 24 2012

Hi all,

While I was doing import I got the following error:

Before I post the error my environment:
source:10.2.0.4,2003 server
Target:11.2.0.3, 2008 R2

on the target I changed block size to 16k,on the source it is 8k

ORA-39083: Object type TABLESPACE failed to create with error:
ORA-29339: tablespace block size 8192 does not match configured block sizes
Failing sql is:
CREATE UNDO TABLESPACE "UNDOTBS" DATAFILE 'F:\ORACLE\ORAD1\DATAFILE\O1_MF_UNDOTBS_1YSSXNCX_.DBF' SIZE 2147483648 AUTOEXTEND ON NEXT 134217728 MAXSIZE 32767M,'H:......dbf' SIZE 1073741824,'H:.......dbf' SIZE 5368709120 BLOCKSIZE 8192 EXTENT MANAGE

Is that ok if i change db_16k_cache_size parameter or do i have to mention remap_tablespaces in the import command??.

Thanks in advance..