About moving all kinds of database files
                                                 Last update (2011-06-06 10:17:57)
                                                                                                                   Date added (2008-02-11 11:45:41)

Summary
As a DBA you must have the scripts to move all kinds of database files. Moving all kind of database files means several things, for example you must be able to :

1. Create a new control file (which means several things).
2. To create a new temporary tablespace.
3. To drop the current UNDO tablespace and create a new one.
4. To rename datafiles (which means moving them to the filesystems).
5. To rename the system datafiles.
6. Move redolog files.
7. Change the destination of trace files

Other links
Create new control file
Create new TEMPORARY tablespace
Create new UNDO tablespace
Move or rename datafiles
Move or rename System 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