Yes. Bring down the db, copy the files over and bring up the db in mounted
mode. Then rename the file using the ALTER DATABASE RENAME FILE command.
Then shutdown, startup and you are in business.
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.
Kelvin Kirkland wrote in message <36cc8126.694721296_at_news.ican.net>...
>Im restructuring my hard drive to better reflect the business;
>however, there are existing databases.
>
>Is there a way for me to physically relocate my datafiles to another
>disk and not have Oracle forget that my tables ever existed?
>
>Any help appreciated
>
>Thanks
>
>Kelvin Kirkland
Received on Thu Feb 18 1999 - 17:15:02 CST
