Re: moving the system tablespace from one filesystem to another

1. Shutdown your database.
2. Move the datafile(s) in question.
3. STARTUP MOUNT
4. Alter database <database name> rename file '< old file name>' to '< new file name >';
5. Shutdown database.
6. Startup normal.

Jeff Kayser
DBDR Inc.

glenamos_at_my-dejanews.com wrote:

> Im in HP-UX and am trying to move a database from one filesystem to another.
> Moving any datafile for a non-system tablespace, redo log file or control
> file is easy enough. How does one move a datafile belonging to the system
> tablespace, since the system tablespace must be online at all times while the
> database is up. Although I doubt there is a difference, I need a solution
> that works for both 7.3 and 8.0.4.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Jul 10 1998 - 23:42:24 CDT