Re: How to increase MAX extent size in a tablespace?

On 28 May 2006 08:39:14 -0700, "jshen.cad_at_gmail.com" <jshen.cad_at_gmail.com> wrote:

>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

There is no such thing as a max extent in a tablespace.

--
Sybrand Bakker, Senior Oracle DBA