I have created a 3G datafile on an external HDD (USB connected). I have set the maxsize to unlimited. Now i wanted to resize this 5GB and i get this error:
ORA-01237: cannot extend datafile 18
ORA-01110: data file 18:f:\path\to\file
ORA-27059: could not reduce file size
OSD-04005: SetFilePointer() failure, unable to read from file
O/S-Error: (OS 112) There is not enough space on the disk
Now i am tryin increase the datafile size not reduce it (unless reduce is resize in Oracle speak). There is 136 free on the disk, hence i cannot understand why its complaining about that. We are running on 10.1.0.4 and O/S Windows Server 2003. The external HDD has a FAT file system, will this make a difference?
I bet the key is "failure, unable to read from file" therefore the error might not have anything to do with diskspace. Can you see the datafile from the os? I would caution against keeping datafiles on a usb drive even for a test system.