Re: Moving datafile

Occassionally I have also had to issue the 'recover datafile datafile_name' command to get the database up and running. Only takes a few seconds.

In article <76afrg$ea0$1_at_nnrp1.dejanews.com>,   alt_at_interchange.co.uk wrote:
> Doug
>
> To move a tablespace log in as SYSTEM and perform the following steps. You may
> want to do this after a backup or take a backup before you begin.
>
> 1) Take your tablespace offline:
>
> SQL> alter tablespace tablespace_name offline;
>
> 2) Copy the datafile to the new location
>
> 3) Tell Oracle the files moved:
>
> SQL> alter tablespace tablespace_name rename datafile
> 'oldpath/filename.dbf'
> to
> 'newpath/filename.dbf';
>
> 4) Bring the tablespace back online:
>
> SQL> alter tablespace tablespace_name online;
>
> 5) Check everythings okay:
>
> SQL> select tablespace_name,file_name from dba_data_files;
>
> 6) Remove old file from old location.
>
> Regards
>
> Alistair Thomson
>
> In article <3688846C.BA79CF86_at_i84.net>,
> Doug Cowles <dcowles_at_i84.net> wrote:
> > Another question - can someone outline basic
> > steps for moving a datafile without bringing
> > the database down? Running out of space on
> > filesystem.
> >
> > - Dc.
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 29 1998 - 14:54:03 CST