| Re: ORA-08103: object no longer exists [message #50890] |
Fri, 12 April 2002 06:50 |
Erik Gomez
Messages: 1
Registered: April 2002
|
Junior Member |
|
|
Parece ser que el problem no tienen nada que ver con el registro en si. Mas bien este problema es debido a las extenciones de datos de ORAcle..
Este problema ocurre en oracle en windows NT cuando la extencion de datos parece exeder los 4GB...
Aqui esta un documento que encontre para solucionar esto...
Espero te sirva... (erikgomez@onebox.com)
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:
a. 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
b. ORA-1237 cannot extend datafile %s
ORA-1110 data file n: '......'
c. 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]]
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
