RE: Alter tablespace add datafile

Thanks for ur help ... I've added the datafile now... couldn't do anything else coz the mount point is running out of space (and sysadmin can't allocated anymore to it!)

Thanks again to everyone

-----Original Message-----
Sent: Thursday, 6 September 2001 2:07 PM To: Multiple recipients of list ORACLE-L

> 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).
-- 
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).