[
https://issues.apache.org/jira/browse/SQOOP-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michele Milesi updated SQOOP-3128:
----------------------------------
Description:
In Sqoop user documentation some oracle privileges are missing from the ones
listed in section "25.8.2.2 Oracle Roles and Privileges".
If you configure the oracle user just with the privileges listed, the sqoop
import fails with huge partitioned tables.
The missing privileges are:
- select on dba_tab_partitions
- select on dba_tab_subpartitions
The missing privileges are listed in section "25.8.2.3. Additional Oracle Roles
And Privileges Required for Export".
was:
In Sqoop user documentation some oracle privileges are missing from the ones
listed in section "25.8.2.2 Oracle Roles and Privileges".
If you configure the oracle user just with the privileges listed the sqoop
import fails with huge partitioned tables.
The two missing privilege are listed in section "25.8.2.3. Additional Oracle
Roles And Privileges Required for Export".
> Missing privileges in "Oracle Roles and Privileges" paragraph (section
> 25.8.2.2)
> --------------------------------------------------------------------------------
>
> Key: SQOOP-3128
> URL: https://issues.apache.org/jira/browse/SQOOP-3128
> Project: Sqoop
> Issue Type: Bug
> Components: docs
> Affects Versions: 1.4.6
> Reporter: Michele Milesi
> Priority: Minor
> Attachments: oracle_privilges.docs.patch
>
>
> In Sqoop user documentation some oracle privileges are missing from the ones
> listed in section "25.8.2.2 Oracle Roles and Privileges".
> If you configure the oracle user just with the privileges listed, the sqoop
> import fails with huge partitioned tables.
> The missing privileges are:
> - select on dba_tab_partitions
> - select on dba_tab_subpartitions
> The missing privileges are listed in section "25.8.2.3. Additional Oracle
> Roles And Privileges Required for Export".
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
