Oracle Scratchpad

January 29, 2022

Distributed catalogue

Filed under: Oracle — Jonathan Lewis @ 6:07 pm GMT Jan 29,2022

This is a list of all articles I’ve written about distributed queries and (particularly) the driving_site() hint. Each entry has a date stamp and a short note of the contents. The articles are generally listed most-recent first.

I am currently working backwards through my entire blog adding articles to catalogues as I go, so any individual catalogue may grow very slowly.

  • Distributed Query (Aug 2021): A real tangle when using the rule, driving_site() and materialize hints.
  • Driving_site() in a patch (May 2021): specific example of a general problem – changing an inline hint to an SQL Patch may require a target query block name and a fully qualified table alias.
  • Distributed Sequences pt.1 (March 2021) – a critical point about inserting into a local table with a local sequence and a fully remote query.
  • Distributed Sequences pt.2 (June 2021) – a little follow-up to the previous note.

1 Comment »

  1. […] Distributed catalogue […]

    Pingback by Catalog Catalogue | Oracle Scratchpad — January 29, 2022 @ 6:09 pm GMT Jan 29,2022 | Reply


RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by WordPress.com.

%d bloggers like this: