{"id":20415,"date":"2022-11-08T16:58:18","date_gmt":"2022-11-08T15:58:18","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=20415"},"modified":"2023-06-20T10:19:29","modified_gmt":"2023-06-20T08:19:29","slug":"oda-do-you-know-the-move-table-in-mysql-db-repository","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/","title":{"rendered":"ODA : Do You Know The MOVE Table In MySQL DB Repository"},"content":{"rendered":"\n<p><strong>By Mouhamadou Diaw<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>During a consulting on a customer, we faced the following issue when trying to delete a dbhome<\/p>\n\n\n\n<p><em>Message:&nbsp; DCS-10001:Internal error encountered: PRGO-2470 : Working copy \u201cOraDB19000_home1\u201d is involved in an incomplete move or upgrade operation<\/em><\/p>\n\n\n\n<p>The result of the job is shown below<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;2022-11-08 10:53:35 root@odaserverb]# odacli describe-job -i 671b5899-02ac-45ff-b5af-ee254ef0bc72\n\nJob details\n----------------------------------------------------------------\n                     ID:  671b5899-02ac-45ff-b5af-ee254ef0bc72\n            Description:  Database Home OraDB19000_home1 Deletion with id a1bfe23e-2569-407b-8b87-7af9f9f586bf\n                 Status:  Failure\n                Created:  October 26, 2022 6:45:49 AM CEST\n                Message:  DCS-10001:Internal error encountered: PRGO-2470 : Working copy \"OraDB19000_home1\" is involved in an incomplete move or upgrade operation..\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nDbHome service deletion for a1bfe23e-2569-407b-8b87-7af9f9f586bf October 26, 2022 6:45:49 AM CEST    October 26, 2022 6:46:02 AM CEST    Failure\nDbHome service deletion for a1bfe23e-2569-407b-8b87-7af9f9f586bf October 26, 2022 6:45:49 AM CEST    October 26, 2022 6:46:02 AM CEST    Failure\nValidate dbhome a1bfe23e-2569-407b-8b87-7af9f9f586bf for deletion October 26, 2022 6:45:50 AM CEST    October 26, 2022 6:45:50 AM CEST    Success\nSetting up ssh equivalance               October 26, 2022 6:45:52 AM CEST    October 26, 2022 6:45:55 AM CEST    Success\nSetting up ssh equivalance               October 26, 2022 6:45:55 AM CEST    October 26, 2022 6:45:58 AM CEST    Success\nDeleting DbHome by RHP                   October 26, 2022 6:45:58 AM CEST    October 26, 2022 6:46:02 AM CEST    Failure\n<\/code><\/pre>\n\n\n\n<p>After researches on the net, we found following Oracle document<\/p>\n\n\n\n<p><em>ODA: Create-prepatchreport fails with PRGP-1005 &#8211; cannot specify databases (Doc ID 2900263.1)<\/em><\/p>\n\n\n\n<p>This document is not about the same issue, but we can find inside that the table MOVE in the database MySQL should be empty in a normal state.<\/p>\n\n\n\n<p>According this document if this table contains rows, it indicates that a move have failed in the past. Indeed we did an upgrade dbhome which failed.<\/p>\n\n\n\n<p>So we decided to follow the steps described in this document and then retry the delete dbhome.<\/p>\n\n\n\n<p><strong>We just want to inform that we do these steps at our own risks and that it\u2019s up to you to execute or not following commands &nbsp;without Oracle support<\/strong><\/p>\n\n\n\n<p>As we are using an HA ODA, we do following tasks on both nodes<\/p>\n\n\n\n<p>We first connect to the MySQL Metadata repository<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;2022-11-08 10:54:07 root@odaserverb]# cd \/opt\/oracle\/dcs\/mysql\/bin\n&#091;2022-11-08 11:31:58 root@odaserverb]# .\/mysql -u root --socket=\/opt\/oracle\/dcs\/mysql\/log\/mysqldb.sock\n<\/code><\/pre>\n\n\n\n<p>We then locate on wich database is the table MOVE<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; select table_schema as database_name, table_name\n    -&gt; from information_schema.tables\n    -&gt; where table_type = 'BASE TABLE'\n    -&gt;     and lower(table_name) like '%move%'\n    -&gt; order by table_schema,\n    -&gt;     table_name;\n+---------------+------------+\n| database_name | TABLE_NAME |\n+---------------+------------+\n| GHSUSER23     | MOVE       |\n+---------------+------------+\n1 row in set (0.00 sec)\n<\/code><\/pre>\n\n\n\n<p>Let\u2019s connect to the GHSUSER23 database and let\u2019s query the table MOVE. And we can see the table is not empty. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt;use GHSUSER23;\n\nmysql&gt; select NAME,SRCWC,SRCHOME,DSTWC,DSTHOME from MOVE;\n+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+------------------------------------------------------+------------------+------------------------------------------------------+\n| NAME                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | SRCWC            | SRCHOME                                              | DSTWC            | DSTHOME                                              |\n+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+------------------------------------------------------+------------------+------------------------------------------------------+\n| 0xACED0005737200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F400000000000017400084F4643434D50524578                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | OraDB19000_home1 | \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1 | OraDB19000_home2 | \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_2 |\n| 0xACED0005737200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000023F400000000000017401354F4643434D5052453B4F7261444231393030305F686F6D65313B2F7530312F6170702F6F64616F7261686F6D652F6F7261636C652F70726F647563742F31392E302E302E302F6462686F6D655F313B4F7261444231393030305F686F6D65323B2F7530312F6170702F6F64616F7261686F6D652F6F7261636C652F70726F647563742F31392E302E302E302F6462686F6D655F323B6F7261636C653B31392E302E302E302E303B5241433B747275653B4E4F545F5350454349464945443B4E4F545F5350454349464945443B66616C73653B4E4F545F5350454349464945443B66616C73653B66616C73653B69726973646576707265613A44425F504F53545F55534552414354494F4E535F535543434553532B69726973646576707265623A53544152545F534552564943455F5355434345535378 | OraDB19000_home1 | \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1 | OraDB19000_home2 | \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_2 |\n+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+------------------------------------------------------+------------------+------------------------------------------------------+\n2 rows in set (0.00 sec)\n<\/code><\/pre>\n\n\n\n<p>We &nbsp;decided to empty the table MOVE, but we did a copy before<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; create table MOVE_BCK as select * from MOVE;\n\nmysql&gt; select NAME,SRCWC,SRCHOME,DSTWC,DSTHOME from MOVE_BCK;\n+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+------------------------------------------------------+------------------+------------------------------------------------------+\n| NAME                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | SRCWC            | SRCHOME                                              | DSTWC            | DSTHOME                                              |\n+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+------------------------------------------------------+------------------+------------------------------------------------------+\n| 0xACED0005737200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F400000000000017400084F4643434D50524578                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | OraDB19000_home1 | \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1 | OraDB19000_home2 | \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_2 |\n| 0xACED0005737200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000023F400000000000017401354F4643434D5052453B4F7261444231393030305F686F6D65313B2F7530312F6170702F6F64616F7261686F6D652F6F7261636C652F70726F647563742F31392E302E302E302F6462686F6D655F313B4F7261444231393030305F686F6D65323B2F7530312F6170702F6F64616F7261686F6D652F6F7261636C652F70726F647563742F31392E302E302E302F6462686F6D655F323B6F7261636C653B31392E302E302E302E303B5241433B747275653B4E4F545F5350454349464945443B4E4F545F5350454349464945443B66616C73653B4E4F545F5350454349464945443B66616C73653B66616C73653B69726973646576707265613A44425F504F53545F55534552414354494F4E535F535543434553532B69726973646576707265623A53544152545F534552564943455F5355434345535378 | OraDB19000_home1 | \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1 | OraDB19000_home2 | \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_2 |\n+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+------------------------------------------------------+------------------+------------------------------------------------------+\n2 rows in set (0.00 sec)\n<\/code><\/pre>\n\n\n\n<p>And then delete the rows<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; delete from MOVE;\nQuery OK, 2 rows affected (0.00 sec)\n\nmysql&gt; commit;\nQuery OK, 0 rows affected (0.00 sec)\n<\/code><\/pre>\n\n\n\n<p>We then retried the delete dbhome<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;2022-11-08 12:05:19 root@odaservera]# odacli list-dbhomes;\n\nID                                       Name                 DB Version                               Home Location                                 Status\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\na1bfe23e-2569-407b-8b87-7af9f9f586bf     OraDB19000_home1     19.14.0.0.220118                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1 FAILED\n06d87fc9-7ebb-4944-aefa-a18f82100506     OraDB19000_home2     19.16.0.0.220719                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_2 CONFIGURED\n<\/code><\/pre>\n\n\n\n<p>And we run the delete-dbhome command on one node<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;2022-11-08 12:05:25 root@odaservera]# odacli delete-dbhome -i a1bfe23e-2569-407b-8b87-7af9f9f586bfAnd the<\/code><\/pre>\n\n\n\n<p>A few minutes after the job finished successfully<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;2022-11-08 12:07:33 root@odaservera]# odacli describe-job -i 79ec29f2-24c8-4bc1-a674-695e81127f0a\n\nJob details\n----------------------------------------------------------------\n                     ID:  79ec29f2-24c8-4bc1-a674-695e81127f0a\n            Description:  Database Home OraDB19000_home1 Deletion with id a1bfe23e-2569-407b-8b87-7af9f9f586bf\n                 Status:  Success\n                Created:  November 8, 2022 12:05:41 PM CET\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nValidate dbhome a1bfe23e-2569-407b-8b87-7af9f9f586bf for deletion November 8, 2022 12:05:41 PM CET    November 8, 2022 12:05:41 PM CET    Success\nSetting up ssh equivalance               November 8, 2022 12:05:43 PM CET    November 8, 2022 12:05:46 PM CET    Success\nSetting up ssh equivalance               November 8, 2022 12:05:46 PM CET    November 8, 2022 12:05:49 PM CET    Success\nDeleting DbHome by RHP                   November 8, 2022 12:05:49 PM CET    November 8, 2022 12:07:53 PM CET    Success\n<\/code><\/pre>\n\n\n\n<p>And we validate with the list-dbhomes<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;2022-11-08 12:07:57 root@odaservera]# odacli list-dbhomes;\n\nID                                       Name                 DB Version                               Home Location                                 Status\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\n06d87fc9-7ebb-4944-aefa-a18f82100506     OraDB19000_home2     19.16.0.0.220719                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_2 CONFIGURED\n<\/code><\/pre>\n\n\n\n<p>Conclusion<\/p>\n\n\n\n<p>Hope this blog help<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Mouhamadou Diaw During a consulting on a customer, we faced the following issue when trying to delete a dbhome Message:&nbsp; DCS-10001:Internal error encountered: PRGO-2470 : Working copy \u201cOraDB19000_home1\u201d is involved in an incomplete move or upgrade operation The result of the job is shown below After researches on the net, we found following Oracle [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,1316,42,59],"tags":[2744,79,2115,2743],"type_dbi":[],"class_list":["post-20415","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-mysql","category-operating-systems","category-oracle","tag-move-ghsuser23","tag-oda","tag-oda-ha","tag-oda-mysql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>ODA : Do You Know The MOVE Table In MySQL DB Repository - 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\/oda-do-you-know-the-move-table-in-mysql-db-repository\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ODA : Do You Know The MOVE Table In MySQL DB Repository\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw During a consulting on a customer, we faced the following issue when trying to delete a dbhome Message:&nbsp; DCS-10001:Internal error encountered: PRGO-2470 : Working copy \u201cOraDB19000_home1\u201d is involved in an incomplete move or upgrade operation The result of the job is shown below After researches on the net, we found following Oracle [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-08T15:58:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-20T08:19:29+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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\/oda-do-you-know-the-move-table-in-mysql-db-repository\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"ODA : Do You Know The MOVE Table In MySQL DB Repository\",\"datePublished\":\"2022-11-08T15:58:18+00:00\",\"dateModified\":\"2023-06-20T08:19:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/\"},\"wordCount\":290,\"commentCount\":1,\"keywords\":[\"MOVE GHSUSER23\",\"ODA\",\"ODA HA\",\"ODA MYSQL\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"MySQL\",\"Operating systems\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/\",\"name\":\"ODA : Do You Know The MOVE Table In MySQL DB Repository - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-11-08T15:58:18+00:00\",\"dateModified\":\"2023-06-20T08:19:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODA : Do You Know The MOVE Table In MySQL DB Repository\"}]},{\"@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\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ODA : Do You Know The MOVE Table In MySQL DB Repository - 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\/oda-do-you-know-the-move-table-in-mysql-db-repository\/","og_locale":"en_US","og_type":"article","og_title":"ODA : Do You Know The MOVE Table In MySQL DB Repository","og_description":"By Mouhamadou Diaw During a consulting on a customer, we faced the following issue when trying to delete a dbhome Message:&nbsp; DCS-10001:Internal error encountered: PRGO-2470 : Working copy \u201cOraDB19000_home1\u201d is involved in an incomplete move or upgrade operation The result of the job is shown below After researches on the net, we found following Oracle [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/","og_site_name":"dbi Blog","article_published_time":"2022-11-08T15:58:18+00:00","article_modified_time":"2023-06-20T08:19:29+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"ODA : Do You Know The MOVE Table In MySQL DB Repository","datePublished":"2022-11-08T15:58:18+00:00","dateModified":"2023-06-20T08:19:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/"},"wordCount":290,"commentCount":1,"keywords":["MOVE GHSUSER23","ODA","ODA HA","ODA MYSQL"],"articleSection":["Database Administration &amp; Monitoring","MySQL","Operating systems","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/","url":"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/","name":"ODA : Do You Know The MOVE Table In MySQL DB Repository - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-11-08T15:58:18+00:00","dateModified":"2023-06-20T08:19:29+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODA : Do You Know The MOVE Table In MySQL DB Repository"}]},{"@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\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/20415","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\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=20415"}],"version-history":[{"count":11,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/20415\/revisions"}],"predecessor-version":[{"id":26146,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/20415\/revisions\/26146"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=20415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=20415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=20415"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=20415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}