Re: Move datafile

Hi.
You have another path to move the datafile. Simply:
1. shutdown oracle + cold-backup all datafiles, controlfiles, redologs, password file

2. copy / move the datafile to the new location
3. startup mount the database
4. rename the datafile while in mount phase (see manuals)
5. alter database open
6. backup control file  (to trace, to file)
7. shutdown and re-caold-backup the database

best regards
Franck

Kathinka Diehl ha scritto nel messaggio <83nnnv$3cb7$1_at_fu-berlin.de>...
>
><buurd_at_my-deja.com> schrieb:
>
>> I'd created a datafile that have been in use for a while now. My
>> problem is that i created the file in the wrong directory (network-
>> drive so it's really the wrong place) and have to move this file and
>> don't know how to do that. Can this be done in a simple way??
>
>The only way I know is to export the datas, remove all datafiles (drop
>tablespace), create new in the right directories and import your database
at
>least. This is not possible, if it is the system tablespace.
>
>HTH, Kathinka
>
>
Received on Thu Jan 20 2000 - 05:13:31 CST