thank you all for the replies, it was because of Bug:711563 Problems with
Datafiles >= 4Gb on Oracle8 on NT Platforms
. i never knew this, but on searching this newsgroup, i found many mention
about this problem previsouly.
thanks.
Pinto.
Bug:711563 Problems with Datafiles >= 4Gb on Oracle8 on NT Platforms
Versions Affected
The problems described here can affect all releases of Oracle8 on NT only.
Platforms Affected
The problems affect Oracle8 releases on all NT platforms
(ie: Both Intel and Alpha NT platforms are affected)
Description
Releases of Oracle8 on NT platforms can exhibit serious problems when
using files larger than 4Gb in size. Some versions of Oracle8 will not
allow such files to be created whilst others can give problems if a file
is resized beyond 4Gb.
Likelihood of Occurrence
It is highly likely that problems will be encountered if an attempt is
made to create or resize a datafile to larger than 4Gb. One should also
avoid migrating an Oracle7 database to Oracle8 if it contains files which
are 4Gb or larger.
NOTE: Resizing includes AUTOEXTEND of a file beyond 4Gb.
Possible Symptoms
There are several possible symptoms from this problem including:
- ORA-1122: database file n failed verification check
ORA-1110: data file n: '......'
ORA-1200: actual file size of n is smaller than correct size
- ORA-1237 cannot extend datafile %s
ORA-1110 data file n: '......'
- If a file is resized above 4Gb it is possible for the file to be
truncated to a much smaller size such that data could be lost from the
file.
Workaround
The only safe workaround at present is to ensure that no file is created
which is >= 4Gb in size. This is best achieved by making sure all
datafiles
are 4095Mb or less and additionally setting MAXSIZE to 4095Mb for files
that are configured to AUTOEXTEND.
NOTE: Attempting to create a file of EXACTLY 4Gb can cause problems.
It is advisable to read the article below which describes potential
issues using files of 2Gb or larger in size as this may influence the
maximum datafile size you choose to use.
Patches
A fix is now available in 8.0.4.3.5 and 8.0.5.1.0a
References
2Gb or not 2Gb - File limits in Oracle [NOTE:62427.1]
Base bug reporting this problem [BUG:711563]
Received on Tue Jun 19 2001 - 04:26:06 CDT
