3 Replies Latest reply: Feb 25, 2013 9:18 AM by Dean Gagne RSS

    Export Consistent parameter

    $phinx19
      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
          $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
            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
              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