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

    Unanswered: Is it possible move system tablespace

    Hai

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

    Thanks in advance
    mohan

  2. #2
    Join Date
    Jan 2003
    Posts
    10
    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
    Jens

Posting Permissions

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