Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to move system tablespace from one filesystem to another?
Another way:
If you haven't done this before make sure you have a good backup before doing anything. Issue the "alter system backup control file to trace" command. Find the trace file thats created. It will contain a create control file command with all the datafiles and paths. Shut down your database cleanly (don't shutdown abort). Move all your datafiles to their new locations, then edit that trace file to reflect the new locations. Execute that trace file from svrmgr and you should be good to go. Don't mess up or you'll be sorry. Did I mention that you should backup everything first?
glen_amos_at_newcourt.com wrote:
> In HP-UX how does one move a datafile belonging to the system tablespace from
> one filesystem to another? My understanding is that the system tablespace
> must always be online when oracle is up and a tablespace must be offline when
> moving a datafile.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon Jun 29 1998 - 22:40:04 CDT