Cloudera Community

Support Questions

Find answers, ask questions, and share your expertise

Advanced Search

Solved

nilesh_shrimant

Contributor

How to use oracle database tns string in Sqoop connect parameter?

1,146 Views

1 ACCEPTED SOLUTION

Master Mentor

One example

sqoop import -D oracle.sessionTimeZone=America/Los_Angeles \
    --connect jdbc:oracle:thin:@//db.example.com/foo --table bar

https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_oracle

View solution in original post

934 Views

1 REPLY 1

Master Mentor

One example

sqoop import -D oracle.sessionTimeZone=America/Los_Angeles \
    --connect jdbc:oracle:thin:@//db.example.com/foo --table bar

https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_oracle

935 Views

Announcements

What's New @ Cloudera

Cloudera Data Engineering 1.23: Access Spark from Your Favor...

What's New @ Cloudera

HBase REST server scaling support is Generally Available

What's New @ Cloudera

New CLI option in the update-database command

What's New @ Cloudera

New Action menu item in the Cloudera Operational Database UI

What's New @ Cloudera

Get the list of supported instance types in the Cloudera Ope...