Re: Rename Database-File in Ora 7.3.4
Date: 2000/06/16
Message-ID: <8id7ii$jef$1_at_nnrp1.deja.com>#1/1
[Quoted] 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