SQOOP - Connecting to ORACLE with direct option gives error

[#1]

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

[#2]

@Shishir Saxena

Catalog role makes sense.

I need to check on why no direct did not work.

It's like sqlldr ...skip checks

[#3]

@fnu rasool

1.Try to run the Sqoop job as a non-root user.

2.Check if your JDK is properly installed on the host and your JAVA_HOME is set properly.

3.Check if you have granted the right permissions to the Databases you're using.

i think there must be a configuration error !