{"id":9360,"date":"2017-01-06T10:22:16","date_gmt":"2017-01-06T09:22:16","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/"},"modified":"2017-01-06T10:22:16","modified_gmt":"2017-01-06T09:22:16","slug":"oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/","title":{"rendered":"Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table"},"content":{"rendered":"

It’s time to a new blog about partitioning improvement in 12cR2.
\nAfter auto-list partitioning<\/a> and multi-column list partitioning & read-only partitions<\/a>, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned table…online !<\/p>\n

As a reminder, the way to convert a table to a partitioned table were to use the DBMS_REDEFINITION<\/em> package (since 9i to 12cR1) which require few steps :<\/p>\n

    \n
  1. Verify that the table is a candidate for redefinition :
    \nDBMS_REDEFINITION.CAN_REDEF_TABLE<\/em><\/li>\n
  2. Create an interim partitioned table<\/li>\n
  3. Start the redefinition :
    \nDBMS_REDEFINITION.START_REDEF_TABLE<\/em><\/li>\n
  4. Copy dependent objects to the new table (grants, constraints, \u2026) :
    \nDBMS_REDEFINITION.COPY_TABLE_DEPENDENTS<\/em><\/li>\n
  5. Synchronize the interim table (optional) :
    \nDBMS_REDEFINITION.SYNC_INTERIM_TABLE<\/em><\/li>\n
  6. Complete the redefinition :
    \nDBMS_REDEFINITION.FINISH_REDEF_TABLE<\/em><\/li>\n<\/ol>\n

    With 12cR2, the conversion can be done in one shot :<\/p>\n

    Non-partitioned table creation :
    \nSQL> CREATE TABLE sales_non_part
    \n (
    \n sales_id NUMBER(5),
    \n sales_name VARCHAR2(30),
    \n sales_city VARCHAR2(20),
    \n sales_amount NUMBER(10)
    \n );
    \nTable created.<\/code><\/p>\n

    Data insertion :
    \nSQL> INSERT INTO sales_non_part VALUES (1, 'JOHN', 'DELEMONT', 10);
    \n1 row created.
    \n<\/br>
    \nSQL> INSERT INTO sales_non_part VALUES (2, 'JANE', 'BERN', 150);
    \n1 row created.
    \n<\/br>
    \nSQL> INSERT INTO sales_non_part VALUES (3, 'JACK', 'NYON', 20);
    \n1 row created.
    \n<\/code><\/p>\n

    Before starting the conversion, I’ll enable the lock tracing to prove that the operation is made online.
    \nYou can take note of the new statement in 12cR2 to enable it :
    \nSQL> ALTER SESSION SET events='trace[ksq] disk medium';
    \n<\/br>
    \nSession altered.<\/code>
    \n(The “old” one was : alter session set events=’10704 trace name context forever, level 3′;<\/em>)<\/p>\n

    Let’s start the conversion of the sales_non_part<\/em> table :
    \nSQL> ALTER TABLE sales_non_part MODIFY PARTITION<\/span> BY LIST (sales_city) AUTOMATIC (PARTITION p_delemont VALUES ('DELEMONT')) ONLINE;
    \n<\/br>
    \nTable altered.<\/code><\/p>\n

    Looks good. Quick check of the partitions :
    \nSQL> SELECT partition_name, high_value FROM dba_tab_partitions WHERE table_name = 'SALES_NON_PART';
    \n<\/br>
    \nPARTITION_NAME HIGH_VALUE
    \n-------------------- ------------------------------
    \nP_DELEMONT 'DELEMONT'
    \nSYS_P5537 'BERN'
    \nSYS_P5538 'NYON'<\/code><\/p>\n

    The table is now partitioned by list and with the AUTOMATIC<\/a> option.
    \nNow, we can check the locks which were applied on the table during the conversion, firstly by finding the objects ID of the table and of the partitions :
    \nSQL> SELECT TO_CHAR(object_id,'0XXXXXXX'), object_name, object_type FROM all_objects WHERE owner='SYS' and object_name='SALES_NON_PART' ORDER BY 2;
    \n<\/br>
    \nTO_CHAR(O OBJECT_NAME OBJECT_TYPE
    \n--------- --------------- ------------------------------
    \n 00011CD1<\/span> SALES_NON_PART TABLE
    \n 00011CE0 SALES_NON_PART TABLE PARTITION
    \n 00011CE1 SALES_NON_PART TABLE PARTITION
    \n 00011CE2 SALES_NON_PART TABLE PARTITION<\/code>
    \nThen by looking for the generated trace file :
    \nSQL> SELECT tracefile FROM v$process WHERE addr=(SELECT paddr FROM v$session WHERE sid=sys_context('USERENV','SID'));
    \n<\/br>
    \nTRACEFILE
    \n----------------------------------------------------------------------
    \n\/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl\/trace\/orcl_ora_8223.trc<\/code><\/p>\n

    And finally by checking inside the file which kind of locks were hold on the objects :
    \nSQL> host cat \/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl\/trace\/orcl_ora_8223.trc | grep -e 00011CD1 -e 00011CE0 -e 00011CE1 -e 00011CE2;
    \n<\/br>
    \n2016-12-16 11:22:09.821*:ksq.c@9006:ksqgtlctx(): *** TM-00011CD1<\/span>-00000000-00000000-00000000 mode=3<\/span> flags=0x401 why=165 timeout=0 ***
    \n2016-12-16 11:22:09.871*:ksq.c@9006:ksqgtlctx(): *** OD-00011CD1-00000000-00000000-00000000 mode=6 flags=0x10401 why=264 timeout=0 ***
    \n2016-12-16 11:22:10.283*:ksq.c@9006:ksqgtlctx(): *** DL-00011CE0-00000000-00000000-00000000 mode=3 flags=0x10001 why=207 timeout=0 ***
    \n2016-12-16 11:22:10.283*:ksq.c@9006:ksqgtlctx(): *** DL-00011CE1-00000000-00000000-00000000 mode=3 flags=0x10001 why=207 timeout=0 ***
    \n2016-12-16 11:22:10.283*:ksq.c@9006:ksqgtlctx(): *** DL-00011CE2-00000000-00000000-00000000 mode=3 flags=0x10001 why=207 timeout=0 ***<\/code><\/p>\n

    One TM-lock mode=3 (Row Exclusive lock) were holds on the table. So the DML operations stay possible during the conversion !
    \nConclusion : the conversion is really done online \ud83d\ude42<\/p>\n

    Information concerning the others locks :
    \nOD\u00a0(Online DDL) lock : used internally to allow truly online DDL operations
    \nDL : lock to prevent index DDL during direct load
    \nTM\u00a0: synchronizes accesses to an object<\/p>\n","protected":false},"excerpt":{"rendered":"

    It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned table…online ! As a reminder, the way to convert a table to a partitioned table were to use the DBMS_REDEFINITION package […]<\/p>\n","protected":false},"author":30,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[958,993,654,994,366],"type_dbi":[],"class_list":["post-9360","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-12cr2","tag-conversion","tag-online","tag-partitioned-table","tag-partitioning"],"acf":[],"yoast_head":"\nOracle 12cR2 : Partitioning improvements - online conversion of a non-partitioned table to a partitioned table - 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-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/\" \/>\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 - online conversion of a non-partitioned table to a partitioned table\" \/>\n<meta property=\"og:description\" content=\"It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned table…online ! As a reminder, the way to convert a table to a partitioned table were to use the DBMS_REDEFINITION package […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-06T09:22:16+00:00\" \/>\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=\"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\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/\"},\"author\":{\"name\":\"Jo\u00ebl Cattin\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780\"},\"headline\":\"Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table\",\"datePublished\":\"2017-01-06T09:22:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/\"},\"wordCount\":341,\"commentCount\":0,\"keywords\":[\"12cR2\",\"conversion\",\"online\",\"partitioned table\",\"Partitioning\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/\",\"name\":\"Oracle 12cR2 : Partitioning improvements - online conversion of a non-partitioned table to a partitioned table - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-01-06T09:22:16+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-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table\"}]},{\"@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 - online conversion of a non-partitioned table to a partitioned table - 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-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12cR2 : Partitioning improvements - online conversion of a non-partitioned table to a partitioned table","og_description":"It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned table…online ! As a reminder, the way to convert a table to a partitioned table were to use the DBMS_REDEFINITION package […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/","og_site_name":"dbi Blog","article_published_time":"2017-01-06T09:22:16+00:00","author":"Jo\u00ebl Cattin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jo\u00ebl Cattin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/"},"author":{"name":"Jo\u00ebl Cattin","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780"},"headline":"Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table","datePublished":"2017-01-06T09:22:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/"},"wordCount":341,"commentCount":0,"keywords":["12cR2","conversion","online","partitioned table","Partitioning"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/","name":"Oracle 12cR2 : Partitioning improvements - online conversion of a non-partitioned table to a partitioned table - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-01-06T09:22:16+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-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-partitioning-improvements-online-conversion-of-a-non-partitioned-table-to-a-partitioned-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table"}]},{"@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\/9360","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=9360"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9360\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9360"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}