Oracle Export Bug, Heads up!
ALERT: EXPORT with large BUFFER can silently produce a dump file with corrupted data
Export Utility (EXP)
Please note: Versions 18.104.22.168 - 22.214.171.124 and 126.96.36.199 - 188.8.131.52 have not been tested but are expected
to be affected by this problem.
After the export (EXP) process, t e produced dump file may contain
corrupted data. See [BUG:2598387] WRONG DATA ON IMPORT AFTER EXPORT VIA CONVENTIONAL PATH
Likelihood of Occurrence
Export with large BUFFER causing data corruption.
The problem could occur when the following formula is satisfied:
----------- >= -----
The problem causes incorrect data to be loaded in the database when a dump is imported.
The problem occurs silently and so there are no errors during the export.
Before export set the environment variable ORA_OCI_NO_OPTIMIZED_FETCH to 1.
setenv ORA_OCI_NO_OPTIMIZED_FETCH 1
ORA_OCI_NO_OPTIMIZED_FETCH=1; export ORA_OCI_NO_OPTIMIZED_FETCH
define/job ORA_OCI_NO_OPTIMIZED_FETCH 1
No patches are currently available.
Patch for [BUG:2410612] does not solve this issue.
WRONG DATA ON IMPORT AFTER EXPORT VIA CONVENTIONAL PATH [BUG:2598387]
I remember when this place was cool.
Click Here to Expand Forum to Full Width