{"id":9241,"date":"2016-12-16T16:10:12","date_gmt":"2016-12-16T15:10:12","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/"},"modified":"2016-12-16T16:10:12","modified_gmt":"2016-12-16T15:10:12","slug":"oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/","title":{"rendered":"Oracle 12cR2 : Partitioning improvements \u2013 multi-column list partitioning & read-only partitions"},"content":{"rendered":"

In my last blog post<\/a> I presented auto-list partitioning, a new partitioning functionality coming with 12cR2.
\nIn this one I will introduce two others : multi-column list partitioning and read-only partitions.<\/p>\n

Multi-column list partitioning<\/h3>\n

\"auto-list-part\"<\/a>Image : “Oracle Partitioning in Oracle Database 12c Release 2” – Hermann B\u00e4r<\/i><\/p>\n

With the first release of 12c it wasn’t possible to create list partitioned tables based on multi-column partition key :
\nORA-14304: List<\/span> partitioning method expects a single partitioning column<\/code>
\nBut now you can easily implement this functionality :
\nSQL> CREATE TABLE cars(
\n car_make VARCHAR2(30),
\n car_model VARCHAR2(30)
\n)
\nPARTITION BY LIST<\/span> (car_make, car_model<\/span>)
\n (PARTITION P1 VALUES ('Ford','Focus'),
\n\t PARTITION P_DEFAULT VALUES (DEFAULT));
\n
\nTable created.
\n<\/code>
\nCheck partitions :
\nSQL> SELECT partition_name, high_value FROM dba_tab_partitions WHERE table_name = 'CARS';
\n<\/br>
\nPARTITION_NAME HIGH_VALUE
\n-------------------- ------------------------------
\nP1 ( 'Ford', 'Focus' )
\nP_DEFAULT DEFAULT
\n<\/br>
\nSQL> SELECT partitioning_type, partition_count, partitioning_key_count FROM dba_part_tables WHERE table_name = 'CARS';
\n<\/br>
\nPARTITION PARTITION_COUNT PARTITIONING_KEY_COUNT
\n--------- --------------- ----------------------
\nLIST 2 2<\/span>
\n<\/code>
\nThis functionality allows you to use up to 16 columns for the partition key and as you can see it in this example, it’s also possible to define a DEFAULT partition.
\nMulti-column list partitioning on subpartitions is also permitted.<\/p>\n

Read-only partitions<\/h3>\n

\"auto-list-part\"<\/a>Image : “Oracle Partitioning in Oracle Database 12c Release 2” – Hermann B\u00e4r<\/i><\/p>\n

We all know that Oracle is able to define a tablespace or a table as read-only. But did you know that with 12cR2 it’s now possible to define this attribute at the partition level ? :
\nCREATE TABLE sales(
\n sales_product VARCHAR2(30),
\n sales_date DATE
\n) READ WRITE<\/span>
\nPARTITION BY RANGE (sales_date)
\n(
\n PARTITION P_2013 VALUES LESS THAN (TO_DATE('01-JAN-2014','dd-MON-yyyy')) READ ONLY<\/span>,
\n PARTITION P_2014 VALUES LESS THAN (TO_DATE('01-JAN-2015','dd-MON-yyyy')) READ ONLY<\/span>,
\n PARTITION P_2015 VALUES LESS THAN (TO_DATE('01-JAN-2016','dd-MON-yyyy')) READ ONLY<\/span>,
\n PARTITION P_2016 VALUES LESS THAN (TO_DATE('01-JAN-2017','dd-MON-yyyy')));<\/code>
\nData insertion :
\nSQL> INSERT INTO sales VALUES ('SHIRT', '02-MAY-2013<\/span>');
\nINSERT INTO sales VALUES ('SHIRT', '02-MAY-2013')
\n *
\nERROR at line 1:
\nORA-14466: Data in a read-only partition or subpartition cannot be modified.<\/span><\/code>
\nSQL> INSERT INTO sales VALUES ('SHOES', '29-MAR-2016<\/span>');
\n<\/br>
\n1 row created.<\/span>
\n<\/code>
\nEasy to implement and reliable way to protect data changes inside a table.<\/p>\n","protected":false},"excerpt":{"rendered":"

In my last blog post I presented auto-list partitioning, a new partitioning functionality coming with 12cR2. In this one I will introduce two others : multi-column list partitioning and read-only partitions. Multi-column list partitioning Image : “Oracle Partitioning in Oracle Database 12c Release 2” – Hermann B\u00e4r With the first release of 12c it wasn’t […]<\/p>\n","protected":false},"author":30,"featured_media":9244,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,368],"tags":[958,976,366,591],"type_dbi":[],"class_list":["post-9241","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-development-performance","tag-12cr2","tag-multi-columns","tag-partitioning","tag-read-only"],"acf":[],"yoast_head":"\nOracle 12cR2 : Partitioning improvements \u2013 multi-column list partitioning & read-only partitions - dbi Blog<\/title>\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\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 12cR2 : Partitioning improvements \u2013 multi-column list partitioning & read-only partitions\" \/>\n<meta property=\"og:description\" content=\"In my last blog post I presented auto-list partitioning, a new partitioning functionality coming with 12cR2. In this one I will introduce two others : multi-column list partitioning and read-only partitions. Multi-column list partitioning Image : “Oracle Partitioning in Oracle Database 12c Release 2” – Hermann B\u00e4r With the first release of 12c it wasn’t […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-16T15:10:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1102\" \/>\n\t<meta property=\"og:image:height\" content=\"171\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jo\u00ebl Cattin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jo\u00ebl Cattin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 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\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/\"},\"author\":{\"name\":\"Jo\u00ebl Cattin\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780\"},\"headline\":\"Oracle 12cR2 : Partitioning improvements \u2013 multi-column list partitioning & read-only partitions\",\"datePublished\":\"2016-12-16T15:10:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/\"},\"wordCount\":188,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled-4.png\",\"keywords\":[\"12cR2\",\"multi-columns\",\"Partitioning\",\"read-only\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Development & Performance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/\",\"name\":\"Oracle 12cR2 : Partitioning improvements \u2013 multi-column list partitioning & read-only partitions - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled-4.png\",\"datePublished\":\"2016-12-16T15:10:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled-4.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled-4.png\",\"width\":1102,\"height\":171},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12cR2 : Partitioning improvements \u2013 multi-column list partitioning & read-only partitions\"}]},{\"@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\/2c774f00321ee734515f0c2f6a96b780\",\"name\":\"Jo\u00ebl Cattin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"caption\":\"Jo\u00ebl Cattin\"},\"description\":\"Jo\u00ebl Cattin has more than three years of experience in databases management. He is specialized in Oracle solutions such as Data Guard and RMAN and has a good background knowledge of Oracle Database Appliance (ODA), Real Application Cluster (RAC) and applications development on APEX. Jo\u00ebl Cattin\u2019s experience includes other RDBMS, such as PostgreSQL and MySQL. He is Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server 9.5 Certified Professional, RedHat Certified System Administrator and ITILv3 Foundation for Service Management Certified. Jo\u00ebl Cattin holds a degree from the \u00c9cole Sup\u00e9rieure d\u2019Informatique de Gestion (ESIG) in Del\u00e9mont and a Federal Certificate of Proficiency in Computer Science (Certificat f\u00e9d\u00e9ral de Capacit\u00e9 \u2013 CFC).\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/joel-cattin\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle 12cR2 : Partitioning improvements \u2013 multi-column list partitioning & read-only partitions - dbi Blog","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\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12cR2 : Partitioning improvements \u2013 multi-column list partitioning & read-only partitions","og_description":"In my last blog post I presented auto-list partitioning, a new partitioning functionality coming with 12cR2. In this one I will introduce two others : multi-column list partitioning and read-only partitions. Multi-column list partitioning Image : “Oracle Partitioning in Oracle Database 12c Release 2” – Hermann B\u00e4r With the first release of 12c it wasn’t […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/","og_site_name":"dbi Blog","article_published_time":"2016-12-16T15:10:12+00:00","og_image":[{"width":1102,"height":171,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled-4.png","type":"image\/png"}],"author":"Jo\u00ebl Cattin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jo\u00ebl Cattin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/"},"author":{"name":"Jo\u00ebl Cattin","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780"},"headline":"Oracle 12cR2 : Partitioning improvements \u2013 multi-column list partitioning & read-only partitions","datePublished":"2016-12-16T15:10:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/"},"wordCount":188,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled-4.png","keywords":["12cR2","multi-columns","Partitioning","read-only"],"articleSection":["Database Administration & Monitoring","Development & Performance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/","name":"Oracle 12cR2 : Partitioning improvements \u2013 multi-column list partitioning & read-only partitions - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled-4.png","datePublished":"2016-12-16T15:10:12+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled-4.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled-4.png","width":1102,"height":171},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-multi-column-list-partitioning-read-only-partitions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12cR2 : Partitioning improvements \u2013 multi-column list partitioning & read-only partitions"}]},{"@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\/2c774f00321ee734515f0c2f6a96b780","name":"Jo\u00ebl Cattin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","caption":"Jo\u00ebl Cattin"},"description":"Jo\u00ebl Cattin has more than three years of experience in databases management. He is specialized in Oracle solutions such as Data Guard and RMAN and has a good background knowledge of Oracle Database Appliance (ODA), Real Application Cluster (RAC) and applications development on APEX. Jo\u00ebl Cattin\u2019s experience includes other RDBMS, such as PostgreSQL and MySQL. He is Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server 9.5 Certified Professional, RedHat Certified System Administrator and ITILv3 Foundation for Service Management Certified. Jo\u00ebl Cattin holds a degree from the \u00c9cole Sup\u00e9rieure d\u2019Informatique de Gestion (ESIG) in Del\u00e9mont and a Federal Certificate of Proficiency in Computer Science (Certificat f\u00e9d\u00e9ral de Capacit\u00e9 \u2013 CFC).","url":"https:\/\/www.dbi-services.com\/blog\/author\/joel-cattin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9241","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\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9241"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9241\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9244"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9241"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}