Operating System - HP-UX
1752579 Members
4449 Online
108788 Solutions
New Discussion юеВ

Re: why could not create tablespace larger 5G?

 
faust2004
Regular Advisor

why could not create tablespace larger 5G?

Hi, expert,
why could not create tablespace larger 5G on
sloris (oracle 805), ulimit -Ha:
root@pub.gz.gdtic.com#ulimit -Ha
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 32768
memory(kbytes) unlimited


THANKS
Sunny
7 REPLIES 7
Justo Exposito
Esteemed Contributor

Re: why could not create tablespace larger 5G?

Hi,

Do you create the lvols with the large files option?

Regards,

Justo.
Help is a Beatiful word
Tom Geudens
Honored Contributor

Re: why could not create tablespace larger 5G?

Hi,
You can check if your filesystem supports largefiles (files larger than > 2Gb) by executing the following command :
fstyp -v /dev/vgxx/lvolxx

This should give you a whole lot of information. Amongst it is f_flag :
IF f_flag=16
THEN your filesystem supports largefiles
ELSE (f_flag = 0) your filesystem does not support largefiles
END IF

Hope this helps,
Tom
A life ? Cool ! Where can I download one of those from ?
T G Manikandan
Honored Contributor

Re: why could not create tablespace larger 5G?

Hello,
On solaris 7 and solaris 8 the file system mounts by default using the large files option.
What version of solaris are you using?

Thanks
faust2004
Regular Advisor

Re: why could not create tablespace larger 5G?

My box is solaris 2.8.
I used: fstyp -v /dev/dsk/c0t0d0s6|grep f_flag. but get nothing
we don't use lv but ufs.

Thanks
Sunny
harry d brown jr
Honored Contributor

Re: why could not create tablespace larger 5G?

You really need to POINT out that you are REFERING to SUN's SOLARIS. It wasn't too clear in your post.

What version of SOLARIS are you using?

live free or die
harry
Live Free or Die
faust2004
Regular Advisor

Re: why could not create tablespace larger 5G?

solaris 2.8
Wodisch
Honored Contributor

Re: why could not create tablespace larger 5G?

Hi Sunny,

what (exactly) is your error?
A little bit more details, please!

Regards,
Wodisch