| lg123 |
Posted: Feb 08, 2008 01:12:11 AM |
Total Post: 5
Joined: Dec, 2007
|
hi,
i wanted to create a tablespace with 32k blocksize.so....
i tryed to create a tablespace with 32k blocksize in 10g(windows)
but could not able to create tablespace with 32k blocksize since my database is already configured for 8k blocksize,
which will be in INIT.ORA file as "db_block_size=8192".
then i tryed to create new database itself with 32k blocksize, i received this error.
ORA-00374 : Parameter db_block_size=32768 invalid.
Must be a multiple of 512 in the range [2048...16384]
i want to know,is the BLOCK SIZE is platform/OS dependent.?
if NO then why im i unable to create database with 32k blocksize in windows xp?
if YES,can u send me how to check the blocksize of OS and which OS supports which blocksizes ?
|
|
|
 Murtuja |
| Posted: Feb 08, 2008 01:36:08 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
You don't need to change db_block_size and this parameter can't be changed after DB creation.
You can create tablespace with 32k block size by this sql
create tablespace
db_32k_tablespace
datafile
'/u01/oradata/mysid/32k_file.dbf'
size
100M
blocksize
32k
;
|
|
|
|
|
| lg123 |
| Posted: Feb 08, 2008 01:55:17 AM | |
|
Total Post: 5
Joined: Dec, 2007
|
I am unable to create that only.
|
|
|
|
|
| Murtuja |
| Posted: Feb 08, 2008 04:05:32 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
I think it's bug.
Bug 2011859 ORA-29339 trying to "CREATE TABLESPACE" with 32K blocksize
Fixed:
This issue is fixed in 9.0.1.3 (Server Patch Set)
9.2.0.1 (Base Release)
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 09, 2008 01:03:53 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
Bug is for only oracle 9i. and OP using oracle 10g.
YOu can't set 32k block size for windows it is OS limit.
you can set "16k" blocksize tablespace.
before that you have to configure "db_16k_cache_size=16k" parameter.
Ver: 10.1.0.5.0 / WinXP
demo:
1. try to set 32k block size.
SQL> alter system set db_32k_cache_size = 32k;
alter system set db_32k_cache_size = 32k
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00382: 32768 not a valid block size, valid range [..]
SQL> create tablespace ttt
2 datafile 'c:\ddd.dbf' size 10m blocksize 32k;
create tablespace ttt
*
ERROR at line 1:
ORA-00382: 32768 not a valid block size, valid range [2048..16384]
3. when try to create 16k blocksize before set "db_16k_cache_size" parameter
SQL> create tablespace ttt
2 datafile 'c:\ddd.dbf' size 10m blocksize 16k;
create tablespace ttt
*
ERROR at line 1:
ORA-29339: tablespace block size 16384 does not match configured block sizes
4. But after setting "db_16k_cache_size" parameter
SQL> create tablespace ttt1
2 datafile 'c:\ddd1.dbf' size 10m blocksize 16k;
Tablespace created.
hope this helps
Taj
|
|
|
|
|
| Murtuja |
| Posted: Feb 10, 2008 11:08:48 PM | |
|
Total Post: 857
Joined: Jan, 2006
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
