Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to access oracle 9i data from 12c

user6375153Feb 13 2015 — edited Feb 13 2015

I heard that oracle does not support data communication between 9i and 12c using db link. are there any methods so that I can access 9i from 12c?

I want to generate a report on customer information.  However, some customer information are stored in 9i and some are stored in 12c.  If I want to combine data from both databases, is the following suggestion technical feasible?

declare 2 jdbc drivers, one for 9i and another for 12c in a java program.  Then, I generate the report by combining the result sets from both drivers.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2015
Added on Feb 13 2015
3 comments
2,188 views