Resizing datafile errors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Resizing datafile errors

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Resizing datafile errors

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    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.
    this space intentionally left blank

  3. #3
    Join Date
    Dec 2001
    Posts
    337
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width