create 8k tablespace

[kumar.j...@gmail.com]

hi friends,
in my database db_block_size=4k
but i want to create 8k block tablespace.
how to create and if not possible y it is...?

[kumar.j...@gmail.com]

hi friends,
iam having a small doubt..
i create a database with db_block_size=4k
now i want to create a 8k block tablespace how we will create a
tablespace..

if it is not possible give me the answer y it is not possible..

[Ashwani Kamboj(Dellhi)]

it is possible in oracle9i , by setting initialization param
db_8k_cache_size
you need to restart the instance before create a tablespace
use
create tablespace tablespace_name datafile 'abc.dbf' size 1m blocksize
8192 , It will create a tablespace of differnet blocksize. yiou can go
upto 32k blocksize

Best Rgds/Ashwani Kamboj(New Delhi)


On Jun 11, 4:18 pm, "kumar.janid...@gmail.com"

[kumar.j...@gmail.com]

hi,
thanq for your sugestion. In 10g the db_block_size=4k. Then we create
4k tablespace defaultly. if we want to create 8k,16k,32k block size
tablespace then at the time of creation we mentioned block size 4k/8k/
16k/32k.

syntax : create tablespace <tablespace_name> datafile '...........'
block size 8k/16k/32k;

but we can't create 2k block size tablespace. b'cause the
db_block_size is 4k. we can't create below the block size.