Re: moving a datafile

1. Get a good offline or cold backup of your database.
2. Then login to the database as a dba and

sql> alter tablespace tablespace_name offline; sql> exit

3) move the file(s) that make up the tablespace (in unix)

mv old_filesystem/filename1 new_filesystem/filename1 mv old_filesystem/filename2 new_filesystem/filename2

4) back into the database

sql> alter database rename file
sql> 'old_filesystem/filename1',
sql> 'old_filesysten/filename2'
sql>  to 
sql> 'new_filesystem/filename1',
sql> 'new_filesystem/filename2';

sql> alter tablespace tablespace_name online;

Doug Cowles <dcowles_at_bigfoot.com> 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 Thu Dec 03 1998 - 17:07:44 CST