OraFAQ Forum: Unix » Oracle/SunOS query

Home » Infrastructure » Unix » Oracle/SunOS query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle/SunOS query [message #215455]

Mon, 22 January 2007 06:23

Clark_Kent07
Messages: 3
Registered: January 2007

Junior Member

Hi,

We are running SunOS ver 5.8 with a 32bit version of Oracle 8. What are the limits to the maximum file sizes with regards the data files and table spaces? Do we suffer from a 2 GB Limit of any of these files?

I read (here) that perhaps some tricks are required to perform exports and things.

If anyone has some experience with this could they please comment. If possible links to oracle / SunOS documentation (or perhaps some other source) would be helpful.

Thanks in adcance

Report message to a moderator

Re: Oracle/SunOS query [message #215462 is a reply to message #215455]

Mon, 22 January 2007 06:50

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

It is the standard workaround
http://orafaq.com/faq/how_does_one_overcome_the_unix_2_gig_file_limit

Report message to a moderator

Re: Oracle/SunOS query [message #215464 is a reply to message #215462]

Mon, 22 January 2007 06:57

Clark_Kent07
Messages: 3
Registered: January 2007

Junior Member

thanks for the tip. Does this problem apply to both tablespace files and data files?

Report message to a moderator

Re: Oracle/SunOS query [message #215468 is a reply to message #215464]

Mon, 22 January 2007 07:08

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> Does this problem apply to both tablespace files and data files?
To be precise, a tablespace is logical.
A Datafile is physical. One or more datafile will make a tablespace.
So there is nothing called as "tablespace files".
A 32 bit OS file cannot grow more than 2gb.
So oracle tablespaces must use multiple datafile that are less than 2gb. For exported dumps etc, you can use the said procedure using pipes to create multiple files.

Report message to a moderator

Re: Oracle/SunOS query [message #215469 is a reply to message #215468]

Mon, 22 January 2007 07:13

Clark_Kent07
Messages: 3
Registered: January 2007

Junior Member

Thank you very much for your help

Report message to a moderator

Previous Topic:	Command to get first line
Next Topic:	unix shell script is not executing .

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 02:33:52 CST 2024