{"id":289,"date":"2008-12-16T10:59:15","date_gmt":"2008-12-16T07:59:15","guid":{"rendered":"http:\/\/blog.yavor.info\/?p=289"},"modified":"2008-12-16T11:35:46","modified_gmt":"2008-12-16T08:35:46","slug":"%d0%b1%d1%8a%d0%b3-%d0%b2-datapump","status":"publish","type":"post","link":"http:\/\/blog.yavor.info\/?p=289","title":{"rendered":"\u0411\u044a\u0433 \u0432 DataPump"},"content":{"rendered":"<p>\u041f\u0440\u0435\u0434\u0438 \u0441\u0435\u0434\u043c\u0438\u0446\u0430 \u0438\u043d\u0441\u0442\u0430\u043b\u0438\u0440\u0430\u0445 11.1.0.7 \u043d\u0430 \u0435\u0434\u043d\u0430 development \u0431\u0430\u0437\u0430, \u0441 \u0438\u0434\u0435\u044f\u0442\u0430 \u043f\u043e\u0441\u043b\u0435 \u0434\u0430 \u0433\u043e \u0441\u043b\u043e\u0436\u0430 \u0438 \u043d\u0430 \u0442\u0435\u0441\u0442\u043e\u0432\u0430\u0442\u0430 \u043f\u043e \u0441\u044a\u0449\u0438\u044f \u043f\u0440\u043e\u0435\u043a\u0442. \u041e\u0431\u0430\u0447\u0435 \u043d\u0430 \u0442\u0430\u0437\u0438 \u0431\u0430\u0437\u0430 \u0441\u0435 \u0437\u0430\u0432\u0438\u0445\u0440\u0438\u0445\u0430 \u0435\u0434\u043d\u0438 ora-600 \u0433\u0440\u0435\u0448\u043a\u0438, \u043a\u043e\u0438\u0442\u043e \u043d\u0435 \u0443\u0441\u043f\u044f\u0445 \u0434\u0430 \u043e\u043f\u0440\u0430\u0432\u044f \u043d\u0430\u0432\u0440\u0435\u043c\u0435 \u0438 \u0437\u0430\u043a\u044a\u0441\u043d\u044f\u0445 \u0441 \u043f\u0430\u0447\u0432\u0430\u043d\u0435\u0442\u043e \u043d\u0430 \u0442\u0435\u0441\u0442\u043e\u0432\u0430\u0442\u0430.<\/p>\n<p>\u0414\u043d\u0435\u0441 \u043f\u0440\u0435\u0442\u0430\u043a\u0430\u0445 \u0435\u0434\u043d\u0438 \u0434\u0430\u043d\u043d\u0438 \u043e\u0442 development \u0431\u0430\u0437\u0430\u0442\u0430 (11.1.0.7) \u0432 \u0442\u0435\u0441\u0442\u043e\u0432\u0430\u0442\u0430 (11.1.0.6). \u0415\u0441\u0442\u0435\u0441\u0442\u0432\u0435\u043d\u043e, \u0441\u043f\u043e\u0440\u0435\u0434 \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u0430 \u043d\u0430 Oracle &#8222;\u043d\u044f\u043c\u0430 \u0441\u043a\u0443\u043a\u0430 \u0442\u0443\u043a\u0430&#8220;, \u043d\u0435\u0449\u0430\u0442\u0430 \u043d\u0435 \u0441\u0442\u0430\u043d\u0430\u0445\u0430 \u043c\u043d\u043e\u0433\u043e \u043b\u0435\u0441\u043d\u043e. \u0418\u043c\u043f\u043e\u0440\u0442\u0430 \u0433\u0440\u044a\u043c\u043d\u0430 \u0441\u044a\u0441 \u0441\u043b\u0435\u0434\u043d\u0430\u0442\u0430 \u0433\u0440\u0435\u0448\u043a\u0430:<\/p>\n<p><code>impdp system@XXXX schemas=XXXX directory=DATA_PUMP_DIR dumpfile=ESODPL_NEW_16122008_2.DMP<\/p>\n<p>Import: Release 11.1.0.6.0 - 64bit Production on Tuesday, 16 December, 2008 9:08:34<\/p>\n<p>Copyright (c) 2003, 2007, Oracle.  All rights reserved.<br \/>\nPassword:<\/p>\n<p>Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production<br \/>\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<br \/>\nORA-39002: invalid operation<br \/>\nORA-31694: master table \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\" failed to load\/unload<br \/>\nORA-02354: error in exporting\/importing data<br \/>\nORA-02373: Error parsing insert statement for table \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\".<br \/>\nORA-00904: \"ORIGINAL_OBJECT_NAME\": invalid identifier<\/code><\/p>\n<p>\u0412\u0435\u0434\u043d\u0430\u0433\u0430 \u0441\u0435 \u0443\u0441\u0435\u0442\u0438\u0445, \u0447\u0435 \u043c\u043e\u0436\u0435 \u0434\u0430 \u043d\u0435 \u043c\u0443 \u0445\u0430\u0440\u0435\u0441\u0432\u0430 \u0432\u0435\u0440\u0441\u0438\u044f\u0442\u0430. \u0421\u044a\u0441 \u0441\u0442\u0430\u0440\u0438\u0442\u0435 exp\/imp \u0431\u0435\u0448\u0435 \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0435\u043b\u043d\u043e \u043b\u0435\u0441\u043d\u043e &#8211; \u043f\u0443\u0441\u043a\u0430\u0448 exp \u043e\u0442 \u043a\u043e\u043c\u043f\u044e\u0442\u044a\u0440, \u043d\u0430 \u043a\u043e\u0439\u0442\u043e \u0438\u043c\u0430 \u043f\u043e-\u0441\u0442\u0430\u0440\u0430\u0442\u0430 \u043e\u0442 \u0434\u0432\u0435\u0442\u0435 \u0432\u0435\u0440\u0441\u0438\u0438 \u0438 \u0432\u0441\u0438\u0447\u043a\u043e \u0437\u0430\u0441\u043f\u0438\u0432\u0430. \u0421\u0435\u0433\u0430, \u043e\u0431\u0430\u0447\u0435, expdp \u0438 impdp \u0441\u0430 \u0441\u0430\u043c\u043e \u043a\u043b\u0438\u0435\u043d\u0442\u0438, \u0430 \u0441\u0430\u043c\u0438\u044f \u0435\u043a\u0441\u043f\u043e\u0440\u0442 \u0441\u0435 \u043f\u0440\u0430\u0432\u0438 \u043e\u0442 database \u0441\u044a\u0440\u0432\u044a\u0440\u0430. \u0417\u0430 \u0442\u0430\u043a\u0438\u0432\u0430 \u0441\u043b\u0443\u0447\u0430\u0438 \u0438\u043c\u0430 \u043f\u0440\u0435\u0434\u0432\u0438\u0434\u0435\u043d\u0430 \u043a\u043b\u0430\u0443\u0437\u0430\u0442\u0430 version:<\/p>\n<p><code>expdp system@XXXX schemas=XXXX directory=data_pump_dir dumpfile=esodpl_new_16122008_3.dmp <strong>version=11.1.0.6<\/strong><\/code><\/p>\n<p>\u0414\u0430, \u043e\u0431\u0430\u0447\u0435&#8230; \u0433\u0440\u0435\u0434\u0430. \u0418 \u043d\u0430\u0438\u0441\u0442\u0438\u043d\u0430, \u0431\u0438 \u0431\u0438\u043b\u043e \u043c\u043d\u043e\u0433\u043e \u043b\u0435\u0441\u043d\u043e \u0430\u043a\u043e \u0432\u0441\u0438\u0447\u043a\u043e \u043f\u0440\u043e\u0441\u0442\u043e \u0441\u0438 \u0440\u0430\u0431\u043e\u0442\u0438. \u0423\u0441\u0435\u0442\u0438\u0445 \u043c\u0438\u0440\u0438\u0437\u043c\u0430\u0442\u0430 \u043d\u0430 \u0431\u0443\u0431\u043e\u043b\u0435\u0447\u043a\u0438 \u0438 \u0440\u0435\u0448\u0438\u0445 \u0434\u0430 \u043f\u043e\u0442\u044a\u0440\u0441\u044f \u043a\u0430\u043a\u0432\u043e \u043f\u0438\u0448\u0435 \u043f\u043e \u0432\u044a\u043f\u0440\u043e\u0441\u0430 \u0432 MetaLink. \u041d\u0435 \u043c\u0438 \u043e\u0442\u043d\u0435 \u043c\u043d\u043e\u0433\u043e \u0432\u0440\u0435\u043c\u0435 \u0434\u0430 \u043d\u0430\u043c\u0435\u0440\u044f Note:752374.1 <em>&#8222;11.1.0.6 Datapump Import of an 11.1.0.7 Dump Fails With ORA-904 &#8222;Original_object_name&#8220;<\/em>. \u041f\u0440\u0438\u0447\u0438\u043d\u0430\u0442\u0430 \u0435 \u043c\u043d\u043e\u0433\u043e \u0431\u043b\u0438\u0437\u0430 \u0434\u043e \u0442\u043e\u0432\u0430, \u043a\u043e\u0435\u0442\u043e \u043f\u0440\u0435\u0434\u043f\u043e\u043b\u043e\u0436\u0438\u0445:<\/p>\n<blockquote><p>This is caused by Bug 7590679.<br \/>\nThe &#8222;ORIGINAL_TABLE_NAME&#8220; column was introduced in 11.1.0.7  by the fix for unpublished Bug 5955150.<\/p>\n<p>This issue reproduces when importing an 11.1.0.7 dump file into 11.1.0.6.<\/p>\n<p>Bug 7590679 is currently being worked by Development who needs to decide between:<br \/>\n&#8211; a\/ the target (11.1.0.6) also needs the fix from unpublished Bug 5955150.<br \/>\n In that case, One-off patches may be created later.<br \/>\n&#8211; b\/ or whether 11.1.0.7 should be capable of creating a Dump files compatible with 11.1.0.6<\/p><\/blockquote>\n<p>\u0420\u0435\u0448\u0435\u043d\u0438\u0435\u0442\u043e, \u043e\u0431\u0430\u0447\u0435, \u043d\u0435 \u043c\u0435 \u0438\u0437\u043a\u0435\u0444\u0438:<\/p>\n<blockquote><p>Having both source and target on 11.1.0.7 will avoid this issue.<\/p>\n<p>To avoid this error, apply our 11.1.0.7 patchset also on the target database.<\/p><\/blockquote>\n<p>\u0412 \u043c\u043e\u043c\u0435\u043d\u0442\u0430 \u043d\u0435 \u043c\u043e\u0433\u0430 \u0434\u0430 \u0441\u043a\u043e\u0447\u0430 \u0438 \u0434\u0430 \u043f\u0430\u0447\u0432\u0430\u043c \u0442\u0435\u0441\u0442\u043e\u0432\u0430\u0442\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430, \u0442\u0440\u044f\u0431\u0432\u0430 \u0434\u0430 \u0438\u0437\u0447\u0430\u043a\u0430\u043c \u043f\u043e\u043d\u0435 \u0434\u043e \u0432\u0447\u0435\u0440\u0442\u0430. \u0417\u0430 \u0442\u043e\u0432\u0430 \u043f\u0440\u043e\u0431\u0432\u0430\u0445 \u0434\u0440\u0443\u0433\u043e \u0440\u0435\u0448\u0435\u043d\u0438\u0435. \u0415\u043a\u0441\u043f\u043e\u0440\u0442\u0438\u0440\u0430\u0445 \u0437\u0430 \u043d\u0430\u0439-\u0441\u0442\u0430\u0440\u0430\u0442\u0430 \u0432\u0435\u0440\u0441\u0438\u044f, \u043a\u043e\u044f\u0442\u043e \u0441\u0435 \u043f\u043e\u0434\u0434\u044a\u0440\u0436\u0430:<\/p>\n<p><code>expdp system@XXXX schemas=XXXX directory=data_pump_dir dumpfile=esodpl_new_16122008_4.dmp <strong>version=10.1<\/strong><\/code><\/p>\n<p>Dump \u0444\u0430\u0439\u043b\u0430 \u0441\u0442\u0430\u043d\u0430 \u043e\u043a\u043e\u043b\u043e \u0434\u0432\u0430 \u043f\u044a\u0442\u0438 \u043f\u043e-\u0433\u043e\u043b\u044f\u043c. \u041d\u043e \u0432\u0430\u0436\u043d\u043e\u0442\u043e \u0435, \u0447\u0435 \u0438\u043c\u043f\u043e\u0440\u0442\u0430 \u043c\u0438\u043d\u0430. \u0422\u043e\u0432\u0430 \u0440\u0435\u0448\u0435\u043d\u0438\u0435 \u043c\u0438 \u0441\u0435 \u0441\u0442\u0440\u0443\u0432\u0430 \u043f\u043e-\u043b\u0435\u0441\u043d\u043e, \u043c\u0430\u043a\u0430\u0440 \u0434\u0430 \u0438\u043c\u0430 \u0438 \u0441\u0442\u0440\u0430\u043d\u0438\u0447\u043d\u0438 \u0435\u0444\u0435\u043a\u0442\u0438.<\/p>\n<p>\u041f\u043e\u0437\u0434\u0440\u0430\u0432\u0438 \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041f\u0440\u0435\u0434\u0438 \u0441\u0435\u0434\u043c\u0438\u0446\u0430 \u0438\u043d\u0441\u0442\u0430\u043b\u0438\u0440\u0430\u0445 11.1.0.7 \u043d\u0430 \u0435\u0434\u043d\u0430 development \u0431\u0430\u0437\u0430, \u0441 \u0438\u0434\u0435\u044f\u0442\u0430 \u043f\u043e\u0441\u043b\u0435 \u0434\u0430 \u0433\u043e \u0441\u043b\u043e\u0436\u0430 \u0438 \u043d\u0430 \u0442\u0435\u0441\u0442\u043e\u0432\u0430\u0442\u0430 \u043f\u043e \u0441\u044a\u0449\u0438\u044f \u043f\u0440\u043e\u0435\u043a\u0442. \u041e\u0431\u0430\u0447\u0435 \u043d\u0430 \u0442\u0430\u0437\u0438 \u0431\u0430\u0437\u0430 \u0441\u0435 \u0437\u0430\u0432\u0438\u0445\u0440\u0438\u0445\u0430 \u0435\u0434\u043d\u0438 ora-600 \u0433\u0440\u0435\u0448\u043a\u0438, \u043a\u043e\u0438\u0442\u043e \u043d\u0435 \u0443\u0441\u043f\u044f\u0445 \u0434\u0430 \u043e\u043f\u0440\u0430\u0432\u044f \u043d\u0430\u0432\u0440\u0435\u043c\u0435 \u0438 \u0437\u0430\u043a\u044a\u0441\u043d\u044f\u0445 \u0441 \u043f\u0430\u0447\u0432\u0430\u043d\u0435\u0442\u043e \u043d\u0430 \u0442\u0435\u0441\u0442\u043e\u0432\u0430\u0442\u0430.<\/p>\n<p>\u0414\u043d\u0435\u0441 \u043f\u0440\u0435\u0442\u0430\u043a\u0430\u0445 \u0435\u0434\u043d\u0438 \u0434\u0430\u043d\u043d\u0438 \u043e\u0442 development \u0431\u0430\u0437\u0430\u0442\u0430 (11.1.0.7) \u0432 \u0442\u0435\u0441\u0442\u043e\u0432\u0430\u0442\u0430 (11.1.0.6). \u0415\u0441\u0442\u0435\u0441\u0442\u0432\u0435\u043d\u043e, \u0441\u043f\u043e\u0440\u0435\u0434 \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u0430 \u043d\u0430 Oracle &#8222;\u043d\u044f\u043c\u0430 \u0441\u043a\u0443\u043a\u0430 \u0442\u0443\u043a\u0430&#8220;, \u043d\u0435\u0449\u0430\u0442\u0430 \u043d\u0435 \u0441\u0442\u0430\u043d\u0430\u0445\u0430 \u043c\u043d\u043e\u0433\u043e \u043b\u0435\u0441\u043d\u043e. \u0418\u043c\u043f\u043e\u0440\u0442\u0430 \u0433\u0440\u044a\u043c\u043d\u0430 \u0441\u044a\u0441 \u0441\u043b\u0435\u0434\u043d\u0430\u0442\u0430 \u0433\u0440\u0435\u0448\u043a\u0430:<\/p>\n<p><code>impdp system@XXXX schemas=XXXX directory=DATA_PUMP_DIR dumpfile=ESODPL_NEW_16122008_2.DMP<\/p>\n<p>Import: Release 11.1.0.6.0 - 64bit Production on Tuesday, 16 December, 2008 9:08:34<br \/>\n<br \/>\nCopyright (c) 2003, 2007, Oracle.  All rights reserved.<br \/>\nPassword:<\/p>\n<p>Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production<br \/>\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<br \/>\nORA-39002: invalid operation<br \/>\nORA-31694: master table \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\" failed to load\/unload<br \/>\nORA-02354: error in exporting\/importing data<br \/>\nORA-02373: Error parsing insert statement for table \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\".<br \/>\nORA-00904: \"ORIGINAL_OBJECT_NAME\": invalid identifier<\/code><\/p>\n<p>(<a href=\"http:\/\/blog.yavor.info\/?p=289\">A\u043a\u043e \u0442\u0438 \u0435 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e, \u0447\u0435\u0442\u0438 \u043d\u0430\u0442\u0430\u0442\u044a\u043a&#8230;<\/a>)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts\/289"}],"collection":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=289"}],"version-history":[{"count":0,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts\/289\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=289"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}