Oracle Linked Servers

Posted on 2007-07-24
Last Modified: 2013-12-19
I come from a SqlServer background and have used "Linked Servers" in the past.
I require to do the same in Oracle now linking a 9i with a 10g database.
I don't even know the correct term to google for! Could someone please help me with some information on how to set this up.  Thanks
Question by:ignition00
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    you need to look into oracle transparent gateways or into heterogeneous services.
    that should help searching.
    LVL 76

    Accepted Solution

    You can connect Oracle to Oracle using simple database links.  It all depends on what you are trying to do once they are connected.

    Check out:

    Author Comment

    Thanks slightwv.
    Spot on.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows how to recover a database from a user managed backup

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now