Q

Moving redo files from one partition to another

Do you know of quick way to relocate/move redo files from one partition to another? I am running Oracle 8.1.7 on Solaris. I remember doing this before.

Moving datafiles is pretty quick and easy. Just follow these steps:

  1. Bring the datafile's tablespace(s) offline:
       ALTER TABLESPACE OFFLINE;
    
  2. Use OS commands to move the datafiles.
  3. Tell the database where the datafiles are now located:
       ALTER DATABASE RENAME FILE '/old_dir/filename' 
       TO '/new_dir/filename';
    
    Do this for every datafile you moved.
  4. Bring the tablespace(s) back online.
       ALTER TABLESPACE ONLINE;
    

For More Information


This was first published in August 2002
This Content Component encountered an error

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