> 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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
