Move or rename System datafiles
                                                 Last update (2011-06-06 10:19:30)
                                                                                                                   Date added (2008-02-11 14:26:00)

Summary
First of all you have to restart the database. Basically is the same with renaming datafiles with some small changes.

How to
For example, lets say that the name of the tablespace is SYSTEM and the datafile is '/filesystem01/system01.dbf' and you want to move it to '/filesystem02/system01.dbf'

1. First shutdown the database
sqlplus "/ as sysdba
shutdown immediate
2. Move the system datafile to the new filesystem with the os command.
$>mv /filesystem01/system01.dbf /filesystem02/system01.dbf
3. Startup and mount the database.
sqlplus>startup mount
4. Do the renaming
ALTER DATABASE RENAME FILE '/filesystem01/tbs01.dbf' TO '/filesystem02/tbs01.dbf';
5. Open the database.
alter database open;
Other links
Create new control file
Create new TEMPORARY tablespace
Create new UNDO tablespace
Move or rename datafiles
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search