Oracle Database Discussions

Hi all,

FYI: I'm running Oracle 10.1.0.5 on Microsoft Windows Server 2003.

I've been instructed to rebuild a database with the db_block_size increased from 8192 to 16384.

I created a new database in a test environment (with the db_block_size set to 16384 and then used imp to import my data into the new blank database.

the logfile indicated that the import completed successfully with warnings, I checked the log and found the following error:

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


IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 8192 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "USER_DATA" BLOCKSIZE 8192 DATAFILE 'E:\ORADATA\DC01\DAT"
"AFILE\O1_MF_USER_DAT_3P7SOWLY_.DBF' SIZE 2500M AUTOEXTEND ON NEXT 104"
"857600 MAXSIZE 32767M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMAN"
"ENT SEGMENT SPACE MANAGEMENT AUTO"

I googled the error message and got the following:

Oracle Error :: ORA-29339
tablespace block size string does not match configured block sizes

Cause
The block size of the tablespace to be plugged in or created does not match the block sizes configured in the database.

Action
Configure the appropriate cache for the block size of this tablespace using one of the various (db_2k_cache_size, db_4k_cache_size, db_8k_cache_size, db_16k_cache_size, db_32K_cache_size) parameters.


but I dont know what the "appropriate" cache for the block size is. Right now, all the cache_size parameters are set to 0 and the db_block_size is set to 8192.

Can anyone steer me in the right direction?

Thanks