RE: Alter tablespace add datafile

Sujatha,
 Here are possible solutions:

1. If the file system, where the datafile resides, has ample space left, then you can resize the existing datafile using following command: alter database datafile '<full-path-name-of-the-data-file>' resize NNNN; where NNNN is number in bytes to which the file will be resized to.
2. You can add a new datafile to the existing tablespace using following command: alter tablespace <tablespace-name> add datafile '<full-path-name-of-the-new-file>' size NNNN; where NNNN is the number in bytes for the size of the datafile.

Yes, you can do this with database up.

Oracle will start using the new space as soon as it needs it.

HTH, Regards,

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Sujatha Madan [SMTP:sujatha.madan_at_cmc.cwo.net.au]
> Sent: Wednesday, September 05, 2001 9:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Alter tablespace add datafile
>
> One of our datafiles is about to reach it's maxsize.
>
> Is the only way around this to do an alter tablespace add datafile?
>
> - Can the database be up and running for this?
> - After I create the new datafile does this mean Oracle will automatically
> use the new one and leave the old one?
> - Is there any other way I can get around this by not shutting down the
> database???
>
> Thanks in advance
>
> sujatha
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sujatha Madan
> INET: sujatha.madan_at_cmc.cwo.net.au
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).