{"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":"2022-11-08T16:58:18","modified_gmt":"2022-11-08T15:58:18","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 class=\"wp-block-paragraph\"><strong>By Mouhamadou Diaw<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">During a consulting on a customer, we faced the following issue when trying to delete a dbhome<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">After researches on the net, we found following Oracle document<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>ODA: Create-prepatchreport fails with PRGP-1005 &#8211; cannot specify databases (Doc ID 2900263.1)<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">So we decided to follow the steps described in this document and then retry the delete dbhome.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\">As we are using an HA ODA, we do following tasks on both nodes<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">Conclusion<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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;&nbsp;<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133,1316,42,59],"tags":[79,2115],"class_list":["post-20415","post","type-post","status-publish","format-standard","category-database","category-mysql","category-operating-systems","category-oracle","tag-oda","tag-oda-ha"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>ODA : Do You Know The MOVE Table In MySQL DB Repository - dbi services 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;&nbsp;\" \/>\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 services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-08T15:58:18+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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\\\/bf7c7eb0bec165183207237c9d0ee1d5\"},\"headline\":\"ODA : Do You Know The MOVE Table In MySQL DB Repository\",\"datePublished\":\"2022-11-08T15:58:18+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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"keywords\":[\"ODA\",\"ODA HA\"],\"articleSection\":[\"Database\",\"MySQL\",\"Operating System\",\"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 services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2022-11-08T15:58:18+00:00\",\"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\":\"Home\",\"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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"caption\":\"Oracle Team\"},\"description\":\"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.\",\"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 services 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;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/oda-do-you-know-the-move-table-in-mysql-db-repository\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2022-11-08T15:58:18+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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\/bf7c7eb0bec165183207237c9d0ee1d5"},"headline":"ODA : Do You Know The MOVE Table In MySQL DB Repository","datePublished":"2022-11-08T15:58:18+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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"keywords":["ODA","ODA HA"],"articleSection":["Database","MySQL","Operating System","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 services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-11-08T15:58:18+00:00","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":"Home","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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","caption":"Oracle Team"},"description":"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.","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":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/20415\/revisions"}],"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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}