Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

SQOOP - Connecting to ORACLE with direct option gives error

Solved Go to solution

SQOOP - Connecting to ORACLE with direct option gives error

While connecting to an ORACLE database with --direct option, gives error

sqoop import --options-file db.config --table table1 --direct -m 4

ORA-00942: table or view does not exist

Same sqoop command works fine without --direct option.

sqoop import --options-file db.config --table table1 -m 4
1 ACCEPTED SOLUTION

Accepted Solutions

Re: SQOOP - Connecting to ORACLE with direct option gives error

userid that is used to login to ORACLE should have SELECT_CATALOG_ROLE to use --direct option.

11 REPLIES 11

Re: SQOOP - Connecting to ORACLE with direct option gives error

Mentor

Re: SQOOP - Connecting to ORACLE with direct option gives error

New Contributor

mapreduce-import-failed.txtHi,

I am getting sqoop import error using oracle tables:

sqoop error tool.importtool error during import import job failed

Can you please advise. I have attached the log for your reference. Thank you.

Re: SQOOP - Connecting to ORACLE with direct option gives error

userid that is used to login to ORACLE should have SELECT_CATALOG_ROLE to use --direct option.

Re: SQOOP - Connecting to ORACLE with direct option gives error

I have accepted this as solution

Re: SQOOP - Connecting to ORACLE with direct option gives error

Thanks Neeraj.

Re: SQOOP - Connecting to ORACLE with direct option gives error

@Shishir Saxena

Table does not exist in oracle database .

Make sure the case sensitivity too in case table exists

Re: SQOOP - Connecting to ORACLE with direct option gives error

Re: SQOOP - Connecting to ORACLE with direct option gives error

New Contributor

Hi,

I am getting sqoop import error using oracle tables:

sqoop error tool.importtool error during import import job failed

Can you please advise. I have attached the log for your reference. Thank you.mapreduce-import-failed.txt

Re: SQOOP - Connecting to ORACLE with direct option gives error

@Neeraj Sabharwal @Artem Ervits Table exists in ORACLE database and user had access to table because I was able to use same sqoop command without --direct option. It had to do with SELECT_CATALOG_ROLE not granted to user. --direct option requires access to ORACLE catalog tables in addition to actual table.