Re: How to move system tablespace from one filesystem to another?

On Fri, 26 Jun 1998 15:41:41 GMT, glen_amos_at_newcourt.com <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.

From Ault's book:

Shutdown the database.
Use cp or dd to copy the file to the new location. In SVRMGR connect internal.
Mount, but don't open the db.
ALTER DATABASE <dbname> RENAME DATAFILE '<oldfile>' to '<newfile>'; Shutdown and restart the db.
Query DBA_DATA_FILES to check that it worked. Now you can delete the old file.

>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Fri Jun 26 1998 - 12:32:14 CDT