Home » Infrastructure » Unix » Oracle/SunOS query
Oracle/SunOS query [message #215455] Mon, 22 January 2007 06:23 Go to next message
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
Re: Oracle/SunOS query [message #215462 is a reply to message #215455] Mon, 22 January 2007 06:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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
Re: Oracle/SunOS query [message #215464 is a reply to message #215462] Mon, 22 January 2007 06:57 Go to previous messageGo to next message
Clark_Kent07
Messages: 3
Registered: January 2007
Junior Member
thanks for the tip. Does this problem apply to both tablespace files and data files?
Re: Oracle/SunOS query [message #215468 is a reply to message #215464] Mon, 22 January 2007 07:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: Oracle/SunOS query [message #215469 is a reply to message #215468] Mon, 22 January 2007 07:13 Go to previous message
Clark_Kent07
Messages: 3
Registered: January 2007
Junior Member
Thank you very much for your help
Previous Topic: Command to get first line
Next Topic: unix shell script is not executing .
Goto Forum:
  


Current Time: Fri Mar 29 04:02:54 CDT 2024