Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Rename Database-File ora 7.3.4
The tric is the alter database rename only renames the file in the control
file. So on OS level you need to rename the file yourself.
Hence
alter the tablespace to offline
shell out to the O/S
rename the file
go back to sqlplus
alter database rename
(followed by alter database backup controlfile to trace)
alter the tablespace back online.
Hth,
Sybrand Bakker, Oracle DBA
"Roland Sippel" <rsippel_at_gus.de> wrote in message
news:39492D86.7171C048_at_gus.de...
> How can i rename (move) a datafile in Oracle 7.3.4 (Win NT 4.0)
> 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.
> With the Storage-Manager it also doesn´t work.
>
> Thanks
> R. Sippel
> hallo_at_rsippel.de
>
>
>
>
Received on Thu Jun 15 2000 - 00:00:00 CDT