True - but with tempfiles that is just about instantaneous anyway. Cheers Connor
--- Glenn Travis <[EMAIL PROTECTED]> wrote: > FYI: This will not work with TEMP tablespaces which > are locally managed. You must drop the tablespace > and recreate it with the new filename. Check > Metalink - it is documented that temporary datafiles > (tempfiles) cannot be renamed. > > > -----Original Message----- > > From: Jeremiah Wilton > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, October 25, 2001 11:40 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Move tablespace with no downtime? > > > > > > Here's a trick I like to reduce the downtime > associated with moving > > large datafiles: > > > > 1. Place the tablespace that contains the file(s) > you want to move > > into backup mode: > > - alter tablespace <name> begin backup; > > > > 2. Copy the file(s): > > - cp <oldfilespec> <newfilespec> > > - If you are moving multiple files, you can do > this in parallel > > > > 3. Take the tablespace out of backup mode: > > - alter tablespace <name> end backup; > > > > 4. (Now the very brief downtile begins) > > Take the tablespace offline immediate > > - alter tablespace <name> offline immediate; > > > > 5. Issue the rename: > > - alter database rename file <oldfilespec> to > <newfilespec>; > > > > 6. Recover the new file(s) or the whole tablespace > (should be quite > > brief) > > - recover [datafile|tablespace] <name>; > > > > 7. (Now the very brief downtime ends) > > Bring the tablespace online again: > > - alter tablespace <name> online; > > > > -- > > Jeremiah Wilton > > http://www.speakeasy.net/~jwilton > > > > On Thu, 25 Oct 2001, Rachel Carmichael wrote: > > > > > depends on what you mean by downtime. > > > > > > yes you can do it without taking down the > database and the instance, > > > no, you can't do it without at least taking the > tablespace offline. > > > > > > alter tablespace x offline; > > > in os, make a copy of all datafiles in the new > location > > > alter database move file 'y' to 'z'; > > > <repeat for all datafiles> > > > alter tablespace online; > > > > > > > > > --- Greg Moore <[EMAIL PROTECTED]> wrote: > > > > Can I move a tablespace and all it's > associated datafiles to a new > > > > disk > > > > device with no downtime? > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > > > -- > > > > Author: Greg Moore > > > > 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). > > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Make a great connection at Yahoo! Personals. > > > http://personals.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > > -- > > > Author: Rachel Carmichael > > > 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: Jeremiah Wilton > > 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: Glenn Travis > 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). ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" ____________________________________________________________ Nokia Game is on again. Go to http://uk.yahoo.com/nokiagame/ and join the new all media adventure before November 3rd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
