help need regarding disk space

[Rajkumar_3]

Hai All ,

I got the error while creating the tablespaces.

Error details:
#########
CREATE TABLESPACE usersdata
*
ORA-01119: error in creating database file '/testing/PROD/users_data.dbf'
ORA-27044: unable to write the header block of file
HP-UX Error: 27: File too large
Additional information: 2
#######################
But for /testing directory the size was assigned 50 GB and it was in the seperate slice.
I think that the error causes insufficient diskspace.when i observer only 4 GB was occupied by /testing directory.

IS there any thing quota that we have to assigned to that /testing/PROD directory.At this situation how can i avoid that insufficient disk space.Is that is not the case what might be the error ??.

Ra

[Justo Exposito]

Hi Rajkumar,

The database file that you want to create is more than 2GB?

If this, then probably you don't declare the lvol with the largefiles option.

You can look for in the /etc/lvmtab.

Regards,

Justo.

[Michael Tully]

Hi,

Has the filesystem been created with the -o largefiles option? If not you will not be able to create a file that is greater than 2Gb.

HTH
-Michael

[Steven Sim Kok Leong]

Hi,

Check that the filesystem that your file resides in supports large files (> 2 GB). To verify, do this:

# fsadm -F hfs /dev/vgXX/lvolYY

(replace hfs with vxfs if your filesystem is a journal filesystem)

where this is the logical volume containing the file system your file resides.

To enable large files in your current runtime environment, do this,

# fsadm -F hfs -o largefiles /dev/vgXX/lvolYY

(replace hfs with vxfs if your filesystem is a journal filesystem)

To enable large files during system reboot, modify your /etc/fstab and add largefiles as an option:

rw,suid,largefiles,delaylog,nodatainlog

Hope this helps. Regards.

Steven Sim Kok Leong

[Printaporn_1]

Hi,


use fsadm to check whether it was create with largefile option or not

#fsadm /dev/vgXX/rlvolXX

if not then you have to
1. re-create using newfs with -o largefiles
or
2. convert using fsadm.

[Ravi_8]

Hi,

create tablespace userdata datafile '/testing/PROD/user_data.dbf' size
xmb;

just a thought.

[Rajkumar_3]

THank you all for the shift responses.

I am trying to recreate the file system with -o option.

Thank you very much.

Raj

[Dennis J Robinson]

While all the comments are correct ( need to recreate filesystem with largefiles option, need to mount it with largefiles option )

One must consider other products they are going to run against the datafiles being created.

For example some versions of gzip don't like large files, some backup products don't.

Most of us simply create datafiles right under the 2GB mark, and use multiple datafiles for a large tablespace.

Ideally heavy activity tablespace would be partitioned, and each partition could fit within a datafile. You could take a portion of the tablespace offline without blocking access to the rest of it.

[Rita C Workman]

Rajkumar,

Just as one very obvious thought...in addition to the recommendations for -o largefiles option.

ORA-01119 is telling you there isn't enough disk space to extend as far as you want.

It is also possible you need to check on how much disk space you have and see if the there is enough physical space to accomodate how far you want to 'extend' the tablespace, first.

Just a thought,
Rita

[Jon_7]

I hate to repeat some of what has already been stated, but file size to large message was from OS, here being HP/UX all the large file options should be checked as above respondants said, and, disk space shoud not be a problem UNLESS you are creating too many files, if you are not, then it is an OS file size issue not disk space, and of course Oracle will not be able to do what the OS will not allow it too, be it too large a file for current settings in OS or, too many files that add up to too large for partition. Good luck. Switches commands and everything else is all above.