Just to make sure that you have sufficient space on that mount point to
resize datafile....If you want increase size by 100MB then that mount point
must have more then 100MB available + some cushion to keep free space....
Regards
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 05 Sep 2001 19:35:31 -0800
- 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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
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).
