File size limitation on OpenVMS?

[ericfjchen]

Hi,

What is a max file size on OpenVMS?
Why does Oracle datafile >= 4 GB on VMS hit a bug? This is Oracle 9.2.0.5. The patch is 2673723. Who can explain for me?

Thanks

FJ

[Marc Van den Broeck · Accepted solution]

Hi,

I guess you have to blame Oracle for it, not Vms :) but are you sure you have downloaded the correct patch version?
Below is an extract from what i found on Oracle metalink:

--------------------------------------------
VERY IMPORTANT:

YOU MUST INSTALL THE FOLLOWING PATCH BEFORE YOU UPGRADE A DATABASE
WITH DATAFILES LARGER THAN 4GB OR TRY TO CREATE SUCH A FILE:

2673723 RDBMS CREATE TABLESPACE WITH DATAFILE 5012M FAILS WITH ORA-600 [2901]

This patch was re-released on June 30th, 2004. Please use the latest version.
The new version includes the fix for:
3735206 RDBMS RESIZE DATAFILE FAILS WITH ORA-1237 / ORA-1110 / ORA-27059

If you had a version of 2673723 installed before the June 30th rerelease, please deinstall 2673723 before reinstalling the new version.

------------------------------------------

We also had problems with datafile larger than 4Gb and i solved it by only using smaller datafiles. But i can imagine that this is not a solution for very large databases.

Rgds
Marc

[Karl Rohwedder]

For more info on this topic see the VMS FAQ at
http://h71000.www7.hp.com/faq/vmsfaq_012.html#file6

regards Kalle