Resizing datafile errors

[Chucks_k]

Hi all,

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?

Any help will be highly appreciated.

Thanks in advance
Chucks

[gandolf989]

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.

[Chucks_k]

Hi,

For reference the problem due to the USB drive having a FAT32 file system, formatted it and recreated with NTFS. I was then able to create datafiles bigger than 4GB.

Thanks,
Chucks