DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle Export Bug, Heads up!

  1. #1
    Join Date
    Jan 2001
    Posts
    3,134

    Oracle Export Bug, Heads up!

    ALERT: EXPORT with large BUFFER can silently produce a dump file with corrupted data
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Versions Affected
    ~~~~~~~~~~~~~~~~~
    Export Utility (EXP)
    8.1.7.3
    8.1.7.4
    9.0.1.4
    9.2.0.1
    9.2.0.2

    Please note: Versions 9.0.1.0 - 9.0.1.3 and 8.1.7.0 - 8.1.7.2 have not been tested but are expected
    to be affected by this problem.

    Platforms Affected
    ~~~~~~~~~~~~~~~~~~
    GENERIC

    Description
    ~~~~~~~~~~~
    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:

    BUFFER_SIZE 65535
    ----------- >= -----
    ROW_LENGTH 2


    Possible Symptoms
    ~~~~~~~~~~~~~~~~~
    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.

    Workaround
    ~~~~~~~~~~
    Before export set the environment variable ORA_OCI_NO_OPTIMIZED_FETCH to 1.
    E.g.:
    UNIX csh:
    setenv ORA_OCI_NO_OPTIMIZED_FETCH 1
    UNIX sh,ksh,bash:
    ORA_OCI_NO_OPTIMIZED_FETCH=1; export ORA_OCI_NO_OPTIMIZED_FETCH
    Windows:
    set ORA_OCI_NO_OPTIMIZED_FETCH=1
    OpenVMS:
    define/job ORA_OCI_NO_OPTIMIZED_FETCH 1

    Patches
    ~~~~~~~
    No patches are currently available.

    Patch for [BUG:2410612] does not solve this issue.

    References
    ~~~~~~~~~~
    WRONG DATA ON IMPORT AFTER EXPORT VIA CONVENTIONAL PATH [BUG:2598387]
    I remember when this place was cool.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Take note all you guys that use export/import as a backup methodology!
    Jeff Hunter

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    Originally posted by marist89
    Take note all you guys that use export/import as a backup methodology!
    D'Oh!

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    My mum told me always to say thank you - so that's what I'm doing.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  5. #5
    Join Date
    Jan 2001
    Posts
    3,134
    My mother used to "place me in a burlap bag and beat me with reeds, pretty standard stuff really"

    Name the quote and win a prize.

    Ps Your quite welcome.

    MH
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width