Summary & Thanks! was-Re: Need help renaming datafile with <cr> in name.

From: <kcary_at_my-dejanews.com>
Date: Thu, 06 May 1999 17:26:47 GMT
Message-ID: <7gsjch$87e$1@nnrp1.deja.com>

Many thanks to all who replied. In the end we used Julio's procedure below in order to make the changes!

In article <3731A61A.63EAC0BB_at_si.unirioja.es>, Julio Negueruela <julio.negueruela_at_si.unirioja.es> wrote:
> First of all, I apologize for my bad English.
>
> kcary_at_my-dejanews.com escribi=F3:
>
> 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=E1tico
> Universidad de La Rioja - Spain
> Telf: 941-299179 Fax: 941- 299180
> mailto:julio.negueruela_at_si.unirioja.es
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu May 06 1999 - 12:26:47 CDT