Re: Move datafile

buurd_at_my-deja.com wrote:
>
> Hi!
> 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??
>
> Tia
>
> --
> Roland Carlsson
> Certified Java programmer
> Skövde
> Sweden
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

HI

Easiest way is via OEM-storage manager.

take the tablespace offline.

Physically move the file

change the info for the datafile in OEM

bring it back on-line (may need to do this from svrmgr and repair it first)

Martin Received on Tue Dec 21 1999 - 05:39:35 CST