Re: Oracle datafile could be greater than 2 GIG in HPUX?

dominica_at_gmail.com wrote:
> Hi All,
>
>
> I have been using solaris(SUN) and linux.
> Now, I have a new production machine which run HPUX(I am not that use
> to UPUX):
>
> uname -a
> HP-UX abc200 B.11.23 U ia64 1168038185 unlimited-user license
>
> I would like to check with this newsgroup that oracle datafile greater
> than 2 Gig is "ok" in
> HPUX.
>
> The thing is even on linux, people are warning me that oracle datafile
> could be greater than 2 Gig,
> but certain tools might not work.
>
> I want to make sure it is OK before I resize my datafile to 4GIG or
> even bigger like 6 Gig.
>
>
> Thanks in advance,
>
>
>
> Dominica
>

You did not say which version of Oracle, but Oracle 8i and higher all have tools that work with files larger than 2GB in size. Largefile support should be enabled on your OS, which most likely it is. After that, you shouldn't have any problems.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com