Q

Moving Oracle from C to E drive

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?

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:
  1. STARTUP MOUNT
  2. ALTER DATABASE RENAME FILE '/directory/filename'

    TO '/new_dir/filename';
  3. Repeat Step 2 for each file that was moved.
  4. 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.
This was first published in November 2006

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close