Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008

    Unanswered: Moving datafiles...


    In Oracle 9i, can we take individual datafiles offline and then copy, rename them and bring the datafile back online?

    or do we have to take the whole tablespace offline first?

    In OEM there is the option to take individual datafiles offline.

  2. #2
    Join Date
    Jul 2003
    this can easily be done.
    9i docs:
    Managing Datafiles
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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