Re: need to increase the tablespace for users

To resize the datafile of your tablespace to 100m

    alter tablespace tablespacename offline     alter database datafile datafilename resize 100m     alter tablespace tablespacename online or add additional datafile to tablespace, say with size 100m

    alter tablespace add datafile datafilename size 100m

john chiu

madhu wrote:

> hi,
>
> I need to increase the table space for the users.
>
> how do I do it.
>
> madhu
Received on Sun Sep 05 1999 - 05:43:59 CDT