Oracle Database Discussions

Hi,

Below question is for oracle 11g database on RHEL.

we are having a CLOB column of 8K. Now the developer is asking to get that increase to 32k how can i make that?

As i know we cannot change "chunk" size once after it is created. I thought we need to recreate a new table with chunk 32k and then export/import the data from old table and drop that old table.

But, the point where i'm struck is ,

the DB_BLOCK_SIZE is 8k. So, can we create a new table with 32k chunk size. Does it conflict?

If thats not possible, i thought an alternative of recreating a tablespace with 32k. I heard that, we can create new tablespace with different db_block_size.. i'm not sure if i'm right? and if you don't mind can you just explain me the lob in-line and out-line.. i read the documents but, i didn't get that well

Can you please suggest me the better way and correct me if i'm wrong..