Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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