Q
Problem solve Get help with specific problems with your technologies, process and projects.

Moving dbf files

I would like to move the dbf files (user01.dbf, tools01.dbf, indx01.dbf, etc.) from one directory to another, as I want to make space in that directory. These files were created at the beginning. I want to know whether I can move these files. I am using SCO UnixWare 7.0.1 and Oracle 8.

I would like to move the dbf files (user01.dbf, tools01.dbf, indx01.dbf, etc.) from one directory to another, as I want to make space in that directory. These files were created at the beginning. I want to know whether I can move these files. I am using SCO UnixWare 7.0.1 and Oracle 8.

You can move the files, but not while the database is using them. You can perform the moves by taking the tablespace offline, moving the file and then instructing Oracle of the new location. Use the following steps:

  1. ALTER TABLESPACE tools OFFLINE;
  2. Use OS commands to move tools01.dbf to its new location.
  3. ALTER DATABASE RENAME FILE '/old_directory/tools01.dbf' TO '/new_directory/tools01.dbf';
  4. ALTER TABLESPACE tools ONLINE;

Repeat for the other tablespaces.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close