Re: need to increase the tablespace for users

Hi all:

   Sorry, my fault. I was testing it on a test database which is running Oracle 7.1.4. The command should work for Oracle 7.2 and up.

Alan Jwo <ajwo_at_gric.com> wrote in message news:LwhB3.1044$6w4.46344_at_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 - 19:03:06 CDT