I have a question about moving Oracle 10g in an SAP environment. I have installed SAP NW2004s SR1 and Oracle 10g 10.1.2.0. and need to move Oracle to the E: drive to free up some space on the C: drive. Do you have any experience with this? Thanks in advance.
Moving the datafiles to a new location will require some downtime. To move a tablespace, you can simply shut down the database, and then move the files to the new location. You will need to let Oracle know where to find the new files. Perform the following actions:
- STARTUP MOUNT
- ALTER DATABASE RENAME FILE '/directory/filename'
- Repeat Step 2 for each file that was moved.
- ALTER DATABASE OPEN;
The RENAME FILE command updates the control file to point to the new location. You can use the above for all of your tablespaces as well as your online redo logs. You will have to handle the control files a little differently. For the control files, shut down the database and copy the control files to the new location. Next, update your initialization parameter file to modify the CONTROL_FILES parameter to the new location. You will be able to start your database.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.