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;
Friday, July 9, 2010
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment