-
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
-
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)
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|