Copying Datafiles on NT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Copying Datafiles on NT

  1. #1
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87

    Copying Datafiles on NT

    Folks,I need you inputs and advice:
    We have 50 datafiles on drive H: size is approx 5GB each, and we want to move the same to drive I: with very less downtime. We did it by copying and altering the database to modify control file everything is fine, but we would like to do it much faster than COPY as this being procution system.I have heard of copying in MULTIPLE STREAMS on NTFS and I do not know how to use it. Oracle 9i Rel 2 on NT.
    Thanks
    sat

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    this is a windows not an oracle question.

    Anyway dont need to redo the control file, just take the tablespace offline, move the file, alter database rename datafile 'xx' to 'yy';
    online the tablespace (this wont work for the system tablespace)

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by davey23uk
    this is a windows not an oracle question.

    Anyway dont need to redo the control file, just take the tablespace offline, move the file, alter database rename datafile 'xx' to 'yy';
    online the tablespace (this wont work for the system tablespace)
    For system and undo, you can be in mount mode for this procedure.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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


Click Here to Expand Forum to Full Width