Re: Need help renaming datafile with <cr> in name.

From: Julio Negueruela <julio.negueruela_at_si.unirioja.es>
Date: Thu, 06 May 1999 16:24:26 +0200
Message-ID: <3731A61A.63EAC0BB@si.unirioja.es>

First of all, I apologize for my bad English.

kcary_at_my-dejanews.com escribió:

This is the right way if your instance is in archive log mode, but...

> SVRMGR> ALTER TABLESPACE "OEM_DATA" OFFLINE NORMAL;
> Statement processed.

//////////////////////////////

Before renaming it into the db you must copy it to the new location at OS level. That is:

$ cp /emc1/oradata/axis/oem_data.dbf /emc1/oradata/axis/oem_data.dbf

///////////////////////////////



> SVRMGR> ALTER DATABASE RENAME FILE


>      2> '/emc1/oradata/axis/oem_data.dbf


>      3> ' TO '/emc1/oradata/axis/oem_data.dbf';

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 Thu May 06 1999 - 09:24:26 CDT