Re: move datafile of system-tablespace

From: Julio Negueruela <julio.negueruela_at_si.unirioja.es>
Date: Wed, 16 Jun 1999 12:15:12 +0200
Message-ID: <37677930.72F64208@si.unirioja.es>

"Rüdiger J. Schulz" escribió:
> =

> hi,
> =

> I want to move the datafile of the system-tablespace to another volume.=

> How?

svrmgrl> Shutdown =

Make a full backup
copy, at OS level, the datafile to the new location =

svrmgrl> Startup mount
svrmgrl> alter database rename file '<old_location>' to '<new_location>';
svrmgrl> alter database open;

where old_location and new_location include the datafile name.

Hope this help.
-- =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Wed Jun 16 1999 - 05:15:12 CDT