RE: Alter tablespace add datafile

> Oracle will see from the total free space of your TABLESPACE, it wont see
from
> datafile level

There's one issue with this, however, to keep in mind. Extents cannot span datafiles. So, more datafiles do add a degree of more fragmentation.

Jon Walthour

-----Original Message-----
Sent: Wednesday, September 05, 2001 11:36 PM To: Multiple recipients of list ORACLE-L

• Instead adding a new datafile you can resize a datafile (oracle 7.3.4 above)
• Adding and resize datafile you can do it online...
• Oracle will automatically manage the space, it doesnt mean if you add a new datafile the old one will not be used anymore, Oracle will see from the total free space of your TABLESPACE, it wont see from datafile level...

Rgds/Jeram
-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thursday, September 06, 2001 8:46 AM

>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: Jeram
  INET: jeram_at_ASABA.CO.ID

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: Walthour, Jon (GEAE, Compaq)
  INET: Jon.walthour_at_ae.ge.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).