Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-3022

sqoop export for Oracle generates tremendous amounts of redo logs

    Details

      Description

      Sqoop export for Oracle generates tremendous amounts of redo logs (comparable to export size or more).

      We have put target tables in nologgin mode, but Oracle will still generate redo logs unless +APPEND Oracle insert hint is used.
      See https://oracle-base.com/articles/misc/append-hint for examples.

      Please add an option for sqoop to generate insert statements in Oracle with APPEND statement. Our databases are swamped with redo/archived logs whenever we sqoop data to them. This is easily avoidable. And from business prospective sqooping to staging tables in nologgin mode is totally fine.

      Thank you.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Tagar Ruslan Dautkhanov
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: