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

<jshen.cad_at_gmail.com> wrote in message
news:1148830754.812037.124990_at_i40g2000cwc.googlegroups.com...
> 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
>

What exactly is the problem you're having?

Please state DB version, OS and version, etc...

-- 
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer


"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup