Friday, July 9, 2010

Move Oracle Datafile to a New location/Partition


You may want to move oracle datafiles to a new disk partition or a new location at some point of time, when your disk space is full or when you are doing a server administration.

Do the Steps shown below

1.Generate the move Data files command as shown below
        SELECT    'ALTER DATABASE RENAME FILE'
                       || NAME
                       || ' TO  <new location>'
                       || NAME
                FROM   v$datafile
2.Shutdown the database
3.Copy or move the data file to its new location. On Unix this can be done with the "dd" command.
        Example in Unix , you can use the dd command :
         dd if=/old/location of=/new/location bs=4096
4. Start up the database in mount state
        startup mount;
5.Move the datafile - Use the statements generated in first step for this.
6. ALTER DATABASE RENAME FILE '/old/location' TO '/new/location';
7. Open the database
ALTER DATABASE OPEN;



 
 

0 comments:

Post a Comment

 

ORA-BLOG. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com