Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, David.

Asked: November 27, 2018 - 7:52 pm UTC

Last updated: November 28, 2018 - 1:44 am UTC

Version: Oracle 12

Viewed 1000+ times

You Asked

Can a database link created on an Oracle 12 database access tables hosted on an Oracle 11 database?

We have an existing application Oracle Argus that we are upgrading to Argus 8.1.2.1 which will run on Oracle 12 Exadata server. We have an existing interface from Argus to Oracle Clinical TMS using Tibco. In the Tibco piece of the interface we use a database link that pulls information from TMS table and populates an Argus Table. Right now that works fine as both databases are hosted on Oracle 11 but after the upgrade Argus will be on Oracle 12. Thus the question.

Thanks for the help.

and Connor said...

Yes you should be fine.

Here's my 12.2 communicating with 11.2.0.4

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production


SQL> select * from v$version where rownum = 1;

BANNER                                                                               CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0

SQL> select * from v$version@db11 where rownum = 1;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production



Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database