Re: Rename Database-File in Ora 7.3.4

From: Eugenio <eugenio.spadafora_nospam_at_compaq.com>
Date: 2000/06/16
Message-ID: <8id9es$5rh$1_at_mailint03.im.hou.compaq.com>#1/1


You can do it with the database "open" if you use

   alter tablespace offline;
   move file from source to target
   alter tablespace rename datafile '.......' to '.......'    alter tablespace online

be sure to move the file before to renaming it and after the tablespace has been take offline.

--
be happy

Eugenio
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
sigdock_at_my-deja.com wrote in message <8id7ii$jef$1_at_nnrp1.deja.com>...

>This one should do the trick. It works on a RS6000 running AIX but that
>shouldn't make any difference:
>
>· Start Oracle Server Manager and connect as Internal.
>· Start and mount the database but do not open it!! Use the command:
>'startup mount exclusive'
>· Move the datafiles to there new destination with Windows Exlorer.
>· Change the specifications from the tablespace 'alter tablespace
><tablespace> rename datafile <old_filenaam> to <new_filenaam>'. The
>filenames must be complete including the pathspecification.
>· Open the database: 'alter database open';
>
>h.t.h.
>
>Bert Jan Meinders
>Oracle DBA
>ASR-ICT
>
>In article <3949300A.27B2100D_at_gus.de>,
> Roland Sippel <rsippel_at_gus.de> wrote:
>> How can i rename (move) a datafile in Oracle 7.3.4 (Win NT 4.0)
>> With the Storage-Manager it also doesn´t work. (ora-error:).
>>
>> The SQL-subscribe in the manual (..offline .. rename .. online)
doesn´t work.
>> (ora-error:).
>> I will move a datafile (userdata2.ora) from one hardisk to other.
>> (From HD: D:\ data\userdata2.ora to E:\data\userdata2.ora)
>> because the file is too big a the time.
>>
>> Thanks 4 help
>> R. Sippel
>> hallo_at_rsippel.de
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Jun 16 2000 - 00:00:00 CEST

Original text of this message