How to increase MAX extent size in a tablespace?

Hi,

One of tablespace in our oracle DB shows MAX extent size is less than 30MB, while the available tablespace size is more than 800MB. I issued
"alter tablespace PDB coalesce;
" , but this does no help.

How can I increase max extent size ?

thanks in advance.

Joe Received on Sun May 28 2006 - 10:39:14 CDT