- vary tablespace offline
- move the data file to the new location
- ALTER DATABASE RENAME FILE 'xxxx' TO 'xxxx';
- vary tablespace online
Amit Agagrwal wrote:
>
> Read Oracle Administration guide. It is very straight forward.
> amit
>
> Doug Cowles wrote:
>
> > Can anyone outline a procedure for moving a datafile
> > to a different filesystem without creating any problems?
> > I'm running out of room fast on a disk, and don't want to
> > interrupt anything.
> >
> > Thanks,
> > Dc.
Received on Tue Dec 08 1998 - 11:44:05 CST
