{"id":47507,"date":"2026-10-12T08:59:00","date_gmt":"2026-10-12T06:59:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=47507"},"modified":"2026-10-05T07:26:53","modified_gmt":"2026-10-05T05:26:53","slug":"removing-instantiation-filtering-from-a-goldengate-replicat","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/","title":{"rendered":"Removing instantiation filtering from a GoldenGate replicat"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In a recent blog, I explained <a href=\"https:\/\/www.dbi-services.com\/blog\/goldengate-instantiation-csn-explained\/\" target=\"_blank\" rel=\"noopener noreferrer\">how instantiation filtering works<\/a>. <code>DBOPTIONS ENABLE_INSTANTIATION_FILTERING<\/code> makes a replicat discard any record whose commit CSN is at or below a table\u2019s instantiation CSN. It applies everything above it. This replicat parameter should be kept during the whole initial load process.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">At some point the replicat has processed past the instantiation boundary for every table, and the filter has nothing left to do. Let\u2019s answer the subsequent and very practical question: <strong>how to confirm, before editing the parameter file, that the replicat has cleared the boundary for every table it maps?<\/strong><\/p>\n\n\n\n<h2 id=\"which-scn-should-i-check-\" class=\"wp-block-heading\">Which SCN should I check ?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To summarize what needs to be checked: <strong>it is safe to remove <code>DBOPTIONS ENABLE_INSTANTIATION_FILTERING<\/code> once the replicat last applied CSN is greater than the instantiation CSN of every table it maps.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To answer this question, you have two sources of information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The per-table boundary, stored in <code>dba_apply_instantiated_objects<\/code>, with one row per source object.<\/li>\n\n\n\n<li>The replicat last applied CSN, stored in the checkpoint table in the <code>log_csn<\/code> column.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"sql-check\" class=\"wp-block-heading\">SQL check<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Read the boundaries first:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT source_database, source_object_owner, source_object_name, instantiation_scn\nFROM dba_apply_instantiated_objects\nORDER BY instantiation_scn DESC;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>SOURCE_DATABASE  SOURCE_OBJECT_OWNER  SOURCE_OBJECT_NAME  INSTANTIATION_SCN\n---------------- -------------------- ------------------- -----------------\nPDB1             APP_PDB1             SALES               52642820\nPDB1             APP_PDB1             ORDERS              52642649<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Then read the replicat last applied CSN from its checkpoint table:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT group_name, log_csn\nFROM oggadmin.checkpoint\nWHERE group_name = 'REP1';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You can safely remove <code>ENABLE_INSTANTIATION_FILTERING<\/code> when <code>log_csn<\/code> is greater than the <strong>highest<\/strong> <code>instantiation_scn<\/code> among the tables it maps. A one-shot verdict, scoped to a single source database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT 'REP1' AS group_name,\nc.log_csn,\nMAX(o.instantiation_scn) AS max_boundary,\nCASE WHEN c.log_csn &gt; MAX(o.instantiation_scn) THEN 'SAFE TO REMOVE' ELSE 'NOT YET' END AS verdict\nFROM dba_apply_instantiated_objects o\nLEFT JOIN oggadmin.checkpoint c ON c.group_name = 'REP1'\nWHERE o.source_database = 'PDB1'\nGROUP BY c.log_csn;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Before a replicat starts for the first time, <code>log_csn<\/code> is <code>NULL<\/code> and the verdict is <code>NOT YET<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GROUP_NAME  LOG_CSN  MAX_BOUNDARY  VERDICT\n----------- -------- ------------- -------\nREP1                 52642820      NOT YET<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">A replicat may map more than one source database, or only a subset of the instantiated objects. Then narrow the join to the objects applied.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>WARNING:<\/strong> A replicat that has never started has no checkpoint row at all, so <code>log_csn<\/code> returns nothing. Treat that as \u201cnot safe\u201d: there is no applied position, so it cannot have cleared anything. The verdict query above handles this case. It starts from the instantiated objects and <strong>left joins<\/strong> the checkpoint table. A missing row gives a <code>NULL<\/code> <code>log_csn<\/code>, and the verdict falls to <code>NOT YET<\/code> instead of the query returning no row at all.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After some time, once the replicat catches up with the initial load, the same query returns:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GROUP_NAME  LOG_CSN   MAX_BOUNDARY  VERDICT\n----------- --------- ------------- --------------\nREP1        52643651  52642820      SAFE TO REMOVE<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You can now cleanly delete the <code>DBOPTIONS ENABLE_INSTANTIATION_FILTERING<\/code> parameter and restart your replicat.<\/p>\n\n\n\n<h2 id=\"adminclient-check\" class=\"wp-block-heading\"><code>adminclient<\/code> check<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">From the <code>adminclient<\/code>, <code>INFO REPLICAT REP1, DETAIL<\/code> reports the applied CSN without using <code>sqlplus<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>OGG&gt; INFO REPLICAT REP1, DETAIL\n...\nLast Committed Transaction CSN value: 52643651<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Compare that number against the <code>instantiation_scn<\/code> from the view exactly as above.<\/p>\n\n\n\n<h2 id=\"rest-api-check\" class=\"wp-block-heading\">REST API check<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The CSN is reachable over the REST API, just not from a GET endpoint. You need to execute a command against the replicat using the <a href=\"https:\/\/docs.oracle.com\/en\/database\/goldengate\/core\/26\/oggra\/op-services-version-replicats-replicat-command-post.html\" target=\"_blank\" rel=\"noopener noreferrer\">POST \/services\/{version}\/replicats\/{replicat}\/command<\/a> endpoint. Using <code>execute_command_replicat<\/code> in the <a href=\"https:\/\/juliendelattre.com\/tools\/ogg-python-client\/\" target=\"_blank\" rel=\"noopener noreferrer\"><code>oggrestapi<\/code><\/a> Python client:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>from oggrestapi import OGGRestAPI\n\nclient = OGGRestAPI(url=\"http:\/\/localhost:7810\", username=\"ogg\", password=\"ogg\")\n\nresp = client.execute_command_replicat(\"REP1\", data={\"command\": \"INFO\", \"arguments\": \"DETAIL\"})\noutput = \"\".join(r&#091;\"reply\"])\nprint(output)<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>Replicat   REP1      Last Started 2026-09-20 13:29   Status RUNNING\nCheckpoint Lag       00:00:00 (updated 00:00:02 ago)\nProcess ID           102660\nLog Read Checkpoint  File aa000000002\n                     2026-09-20 13:30:17.000000  RBA 18926\nEncryption Profile   LocalWallet\n\nCurrent Log BSN value: 52643543\n\nLast Committed Transaction CSN value: 52646310\n\n  Extract Source                          Begin             End\n\n  aa000000002                             2020-01-01 00:00  2026-09-20 13:30:17.00\n  aa000000000                             * Initialized *   2020-01-01 00:00:00.00\n  aa000000000                             * Initialized *   First Record<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">To be truly automated, <code>Last Committed Transaction CSN value<\/code> has to be parsed out:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import re\n\nmatch = re.search(r\"Last Committed Transaction CSN value: (\\d+)\", output)\napplied_csn = int(match.group(1))\nprint(applied_csn)<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>52646310<\/code><\/pre>\n\n\n\n<h2 id=\"information-in-the-report-file\" class=\"wp-block-heading\">Information in the report file<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When starting a replicat during an initial load, the report file is filled with the following lines:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>OGG-10155  Instantiation CSN filtering is enabled on table PDB1.APP_PDB1.ORDERS at CSN 52,642,649.\nOGG-10185  Instantiation CSN filtering on table PDB1.APP_PDB1.ORDERS has started at CSN 52642649.\nOGG-10186  Instantiation CSN filtering on table PDB1.APP_PDB1.ORDERS has ended, now passing transactions starting at CSN 52642649.<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If the trail the replicat reads on that start contains records <strong>below<\/strong> a boundary, it filters them, and these lines appear.<\/li>\n\n\n\n<li>If the trail begins <strong>at or after<\/strong> the boundary, nothing is filtered and <strong>no line appears at all<\/strong>.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"performance-impact-of-leaving-enable_instantiation_filtering\" class=\"wp-block-heading\">Performance impact of leaving <code>ENABLE_INSTANTIATION_FILTERING<\/code><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When migrating a database online with GoldenGate, you want your replicat to catch up quickly. I tested whether keeping <code>ENABLE_INSTANTIATION_FILTERING<\/code> in the parameter file had any effect on the lag of a replicat. I found no significant statistical evidence of this.<\/p>\n\n\n\n<h2 id=\"summary\" class=\"wp-block-heading\">Summary<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>ENABLE_INSTANTIATION_FILTERING<\/code> is <strong>safe to remove<\/strong> when the replicat <code>log_csn<\/code> (last applied CSN) is above the <code>instantiation_scn<\/code> of every table it maps.<\/li>\n\n\n\n<li>Get the applied CSN from <code>oggadmin.checkpoint.log_csn<\/code> (<code>sqlplus<\/code>), <code>INFO REPLICAT REP1, DETAIL<\/code> (<code>adminclient<\/code>), or <code>execute_command_replicat(\"REP1\", data={\"command\": \"INFO\", \"arguments\": \"DETAIL\"})<\/code> over REST, which returns the same information.<\/li>\n\n\n\n<li>The <code>OGG-10155\/10185\/10186<\/code> report lines appear <strong>only when the replicat filters records on that start<\/strong>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In a recent blog, I explained how instantiation filtering works. DBOPTIONS ENABLE_INSTANTIATION_FILTERING makes a replicat discard any record whose commit CSN is at or below a table\u2019s instantiation CSN. It applies everything above it. This replicat parameter should be kept during the whole initial load process. At some point the replicat has processed past the [&hellip;]<\/p>\n","protected":false},"author":152,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[3787,59],"tags":[3804,639,4232,734,4256,328,4236,3730,96,3976,4255],"type_dbi":[3823,4257,4260,4259,4262,3740,4258,3881,2728,3977,4261],"class_list":["post-47507","post","type-post","status-publish","format-standard","hentry","category-goldengate","category-oracle","tag-26ai","tag-checkpoint","tag-csn","tag-datapump","tag-enable_instantiation_filtering","tag-goldengate","tag-instantiation","tag-ogg","tag-oracle","tag-replicat","tag-rest-api-2","type-26ai","type-checkpoint","type-csn","type-datapump","type-enable_instantiation_filtering","type-goldengate","type-instantiation","type-ogg","type-oracle","type-replicat","type-rest-api-3"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.6 (Yoast SEO v28.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Removing instantiation filtering from a GoldenGate replicat - dbi Blog<\/title>\n<meta name=\"description\" content=\"Check that a replicat has cleared every table&#039;s instantiation CSN before removing instantiation filtering (ENABLE_INSTANTIATION_FILTERING).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Removing instantiation filtering from a GoldenGate replicat\" \/>\n<meta property=\"og:description\" content=\"Check that a replicat has cleared every table&#039;s instantiation CSN before removing instantiation filtering (ENABLE_INSTANTIATION_FILTERING).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-12T06:59:00+00:00\" \/>\n<meta name=\"author\" content=\"Julien Delattre\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julien Delattre\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/removing-instantiation-filtering-from-a-goldengate-replicat\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/removing-instantiation-filtering-from-a-goldengate-replicat\\\/\"},\"author\":{\"name\":\"Julien Delattre\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\"},\"headline\":\"Removing instantiation filtering from a GoldenGate replicat\",\"datePublished\":\"2026-10-12T06:59:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/removing-instantiation-filtering-from-a-goldengate-replicat\\\/\"},\"wordCount\":566,\"commentCount\":0,\"keywords\":[\"26ai\",\"checkpoint\",\"csn\",\"DataPump\",\"enable_instantiation_filtering\",\"GoldenGate\",\"instantiation\",\"ogg\",\"Oracle\",\"replicat\",\"rest api\"],\"articleSection\":[\"GoldenGate\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/removing-instantiation-filtering-from-a-goldengate-replicat\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/removing-instantiation-filtering-from-a-goldengate-replicat\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/removing-instantiation-filtering-from-a-goldengate-replicat\\\/\",\"name\":\"Removing instantiation filtering from a GoldenGate replicat - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2026-10-12T06:59:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\"},\"description\":\"Check that a replicat has cleared every table's instantiation CSN before removing instantiation filtering (ENABLE_INSTANTIATION_FILTERING).\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/removing-instantiation-filtering-from-a-goldengate-replicat\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/removing-instantiation-filtering-from-a-goldengate-replicat\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/removing-instantiation-filtering-from-a-goldengate-replicat\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Removing instantiation filtering from a GoldenGate replicat\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\",\"name\":\"Julien Delattre\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"caption\":\"Julien Delattre\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/juliendelattre\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Removing instantiation filtering from a GoldenGate replicat - dbi Blog","description":"Check that a replicat has cleared every table's instantiation CSN before removing instantiation filtering (ENABLE_INSTANTIATION_FILTERING).","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/","og_locale":"en_US","og_type":"article","og_title":"Removing instantiation filtering from a GoldenGate replicat","og_description":"Check that a replicat has cleared every table's instantiation CSN before removing instantiation filtering (ENABLE_INSTANTIATION_FILTERING).","og_url":"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/","og_site_name":"dbi Blog","article_published_time":"2026-10-12T06:59:00+00:00","author":"Julien Delattre","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Julien Delattre","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/"},"author":{"name":"Julien Delattre","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"headline":"Removing instantiation filtering from a GoldenGate replicat","datePublished":"2026-10-12T06:59:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/"},"wordCount":566,"commentCount":0,"keywords":["26ai","checkpoint","csn","DataPump","enable_instantiation_filtering","GoldenGate","instantiation","ogg","Oracle","replicat","rest api"],"articleSection":["GoldenGate","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/","url":"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/","name":"Removing instantiation filtering from a GoldenGate replicat - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2026-10-12T06:59:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"description":"Check that a replicat has cleared every table's instantiation CSN before removing instantiation filtering (ENABLE_INSTANTIATION_FILTERING).","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/removing-instantiation-filtering-from-a-goldengate-replicat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Removing instantiation filtering from a GoldenGate replicat"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e","name":"Julien Delattre","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","caption":"Julien Delattre"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/juliendelattre\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/47507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/152"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=47507"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/47507\/revisions"}],"predecessor-version":[{"id":47629,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/47507\/revisions\/47629"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=47507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=47507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=47507"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=47507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}