Hello,

I have a question. Our drives where all of our database files needs to be defragmented. Does Oracle needs to be shutdown or can the database remain open while disk defrag is occuring?

Thanks much,
Oraclelearner

I found the answer to my question by an article written by SteveC @ http://www.dbasupport.com/oracle/ora9i/onWindows02.shtml

Regards,
Oraclelearner

>> Our drives where all of our database files needs to be defragmented.

What, are you on a PC or something?

If you have created your I/O subsystem properly:

1 - There should be nothing other than dbf files on the Oracle partitions
2 - Oracle data files never fragment (except when extending, and you don't use defrag for that)

>> I found the answer to my question by an article written by SteveC

I'd watch out for him, but thanks for sharing . . . .

Who is that masked stranger?

Another option is to copy the files elsewhere, reformat the disk, put files back.

Thanks Mr. Burleson and SteveC for your timely responses!