sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ruslan Dautkhanov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-3022) sqoop export for Oracle generates tremendous amounts of redo logs
Date Thu, 06 Oct 2016 20:30:20 GMT
Ruslan Dautkhanov created SQOOP-3022:
----------------------------------------

             Summary: sqoop export for Oracle generates tremendous amounts of redo logs
                 Key: SQOOP-3022
                 URL: https://issues.apache.org/jira/browse/SQOOP-3022
             Project: Sqoop
          Issue Type: Bug
          Components: codegen, connectors, connectors/oracle
    Affects Versions: 1.4.6, 1.4.5, 1.4.4, 1.4.3
            Reporter: Ruslan Dautkhanov


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message