Re: RE:TABLESPACE INCREASING

In article <rwh4.9.000E5802_at_pitt.edu>, rwh4_at_pitt.edu (Richard W. Harris) wrote:
>
> In article <2uupjt$7im_at_podsun6.cc.binghamton.edu> bpanko_at_podsun6.cc.binghamton.edu (bpanko) writes:
> >From: bpanko_at_podsun6.cc.binghamton.edu (bpanko)
> >Subject: RE:TABLESPACE INCREASING
> >Date: 30 Jun 1994 11:50:21 -0400
>
>
> >HI,USERS
 
> >I am new to ORACLE (6.0).
> >Would really appreciate if I get a quick and dirty way to fix this:
> >"database is out of space! Increase tablespace before proceeding.
> >error during connect - 1547"
> >I guess I ought to use SQLDBA>alter tablespace command.
> >Could you also explain all the terms tablespace and stuff.
> >Do I need to do it "Offline" and anything else.
>
> Hi,
>
> Your guess is correct. You need to do the following command:
>
> ALTER TABLESPACE <tablespace-name>
> ADD DATAFILE '<new-tablespace-datafile>'
> SIZE <new-tablespace-datafile-size>;
>

Dont' forget to do a complete backup of your database including the control file after you have added the new space. The above command alters control file and it is essential to have a copy of it for any recovery procedures. You may also need to update your backup command to add the name of any new data files added above.

-Jeff Rule/Apple Computer e-mail:rule_at_apple.com Received on Fri Jul 01 1994 - 20:37:20 CEST