Printable View
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
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.Quote:
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)