This discussion is archived
3 Replies Latest reply: Feb 25, 2013 7:18 AM by Dean Gagne RSS

Export Consistent parameter

$phinx19 Newbie
Currently Being Moderated
Hi All,

When we set Consistent parameter as yes during export, we get a consistent dump of the database/ schema from the point it was taken by setting the transaction Read only.
So let say we are exporting a table TAB_1 and at the same time a different user updates one of the row of this table and then another user updated this row again so and so forth. So from where do export gets the image of this row which was present at the point in time when the export was initiated in the first place. Is it the Undo?

Regards,
Spohinx
  • 1. Re: Export Consistent parameter
    sb92075 Guru
    Currently Being Moderated
    $phinx19 wrote:
    Hi All,

    When we set Consistent parameter as yes during export, we get a consistent dump of the database/ schema from the point it was taken by setting the transaction Read only.
    So let say we are exporting a table TAB_1 and at the same time a different user updates one of the row of this table and then another user updated this row again so and so forth. So from where do export gets the image of this row which was present at the point in time when the export was initiated in the first place. Is it the Undo?

    Regards,
    Spohinx
    >
    Hi All,

    When we set Consistent parameter as yes during export, we get a consistent dump of the database/ schema from the point it was taken by setting the transaction Read only.
    So let say we are exporting a table TAB_1 and at the same time a different user updates one of the row of this table and then another user updated this row again so and so forth. So from where do export gets the image of this row which was present at the point in time when the export was initiated in the first place. Is it the Undo?

    Regards,
    Spohinx
    yes, from UNDO
  • 2. Re: Export Consistent parameter
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    The answer is, amazingly, in the documentation ;-)

    http://docs.oracle.com/cd/E11882_01/server.112/e22490/original_export.htm#sthref1823

    HTH
    Srini
  • 3. Re: Export Consistent parameter
    Dean Gagne Expert
    Currently Being Moderated
    You don't mention if you use expdp or exp. For exp, it is done by setting the transaction to read only, for expdp, it is done by using flashback.

    Dean

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points