Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MOVE DATAFILE SCO UNIX possible ?
Sean Kubovcik wrote:
>
> Try:
> Take tablespace offline
> At OS, copy old file to new file system
> Run: alter database 'old /dir/file' to 'new /dir/file';
> Put tablespace online
> Test
> Delete old file
> Reference page 7-13 of the Oracle7 Server Admin Guide, 'Renaming and
> relocating data files'.
> Sean
>
> >Hello,
> >
> >i made a small mistake. I made a datafile on the wrong disk, is it
> >possible to move this to the right place.
> >
> >Please HELP !!!!!!!!!!!!!!!!!
> >
> >
> >BTW it is a part of the system tablespace.
> >
> >Greatings,
> >
> >Erik Oosterling
> >
I think you would need to do:
alter database rename file 'oldfile' to 'newfile' Received on Mon Jan 27 1997 - 00:00:00 CST