From jeram@ASABA.CO.ID Wed, 05 Sep 2001 19:26:38 -0700 From: "Jeram" Date: Wed, 05 Sep 2001 19:26:38 -0700 Subject: Re: Alter tablespace add datafile Message-ID: MIME-Version: 1.0 Content-Type: text/plain - 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 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@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@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@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@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).