Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Unanswered: Is it possible move system tablespace


    Is it possible move system tablespace to another drive and how to move redo log files to another drive .

    Thanks in advance

  2. #2
    Join Date
    Jan 2003
    Hi Mohan,

    yes, it is possible.

    Fisrt you have to shutdown the db and move the files (Datafiles and Logfiles) to the new location.

    Then startup the db in mount mode.
    Now you can rename the files in the controlfile with the alter database rename statement.

    > alter database rename file 'OLDNAME' to 'NEWNAME';

    After renameing the files you can open the db:

    > alter database open;

    good luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts