hardik_982, surely if the file #201 is not in the dba_data_files list, it is a temp file of some kind.... I don´t have here a Win2003 to check, but maybe you have in it a HARD LIMIT to file sizes, the tempfiles are AUTOEXTENSIBLE and UNLIMITED in size, the query refreshing the MV is complex and it is consuming temp space, the tempfiles are automatically growing and passing the SO/hardware max size limit ?? The message "attempt to do i/o beyond the range of file" seams to confirm this hypothesis... Check this, if so simply recreate the temp tablespace with tempfiles having a (for your platform) valid MAXSIZE size, or even don´t use AUTOEXTEND at all and create the temp with the required size...

Regards,

Chiappa
Junior Member