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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: