{"id":230,"date":"2005-02-07T15:32:57","date_gmt":"2005-02-07T21:32:57","guid":{"rendered":"http:\/\/www.mooreds.com\/wordpress\/?p=230"},"modified":"2005-02-07T15:32:57","modified_gmt":"2005-02-07T21:32:57","slug":"database-links","status":"publish","type":"post","link":"https:\/\/www.mooreds.com\/wordpress\/archives\/230","title":{"rendered":"Database links"},"content":{"rendered":"<p>I just discovered <a href='http:\/\/www.ss64.com\/ora\/link_c.html'>database links<\/a> in Oracle.  This is a very cool feature which essentially allows you to (nearly) transparently pull data from one Oracle database to another.  Combined with a view, you can have a read only copy of production data, real time, without giving a user access to the production database directly.  <\/p>\n<p>Along with the above link, section 29 of the <u>Database Administrator&#8217;s Guide<\/u>, <a href='http:\/\/download-west.oracle.com\/docs\/cd\/B10501_01\/server.920\/a96521\/ds_admin.htm'>Managing a Distributed Database<\/a>, is useful.  But I think you need an OTN account to view that link.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I just discovered database links in Oracle. This is a very cool feature which essentially allows you to (nearly) transparently pull data from one Oracle database to another. Combined with [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-230","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/comments?post=230"}],"version-history":[{"count":0,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/230\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/media?parent=230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/categories?post=230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/tags?post=230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}