Re: need to increase the tablespace for users

From: Alan Jwo <ajwo_at_gric.com>
Date: Tue, 7 Sep 1999 16:49:31 -0700
Message-ID: <LwhB3.1044$6w4.46344@nuq-read.news.verio.net>

Hi John:

Is your first approach only available on Oracle 8? I tried it with my Oracle 7.3.x database and it failed. The error message says "ORA-01916: ONLINE keyword or OFFLINE keyword expected" after I tried to run "alter database datafile datafilename resize 100m".

John Chiu <johnymc_at_netscape.com> wrote in message news:37D2496F.ADDBB28E_at_netscape.com...
> 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 Tue Sep 07 1999 - 18:49:31 CDT