{"id":85,"date":"2009-06-05T12:38:39","date_gmt":"2009-06-05T10:38:39","guid":{"rendered":"http:\/\/demeringo.ovh.org\/blog\/?p=85"},"modified":"2009-11-23T14:34:05","modified_gmt":"2009-11-23T13:34:05","slug":"import-dump-in-oracle-xe","status":"publish","type":"post","link":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/?p=85","title":{"rendered":"Import dump in Oracle XE"},"content":{"rendered":"<p><strong>Import an Oracle dump to oracle XE in 3 steps:<\/strong><\/p>\n<ul>\n<li>Create a directory to contain a new tablespace<\/li>\n<li>Create a dedicated tablespace and user that reflects the name of the ones used to export<\/li>\n<li>Import the dump into this new tablespace<\/li>\n<\/ul>\n<p><strong>Detailled instructions<\/strong><\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\nCreate a directory for Data (tablespace)<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<pre lang=\"bash\">mkdir C:\\myDataFiles<\/pre>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\nCreate a TAB_CS tablespace<\/p>\n<p>Use exactly this name as it will be requested for import<br \/>\nConnect to XE as System user (use SQL developper for instance)<br \/>\nand run the following script and COMMIT !<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<pre lang=\"SQL\">CREATE\u00a0 TABLESPACE TAB_CS\r\nDATAFILE 'C:\\myDataFiles\\TAB_CS.ora'\r\nSIZE 10M\r\nAUTOEXTEND ON NEXT 5M;\r\n\r\nCREATE\u00a0 USER MyUser\r\nIDENTIFIED BY MyPass\r\nDEFAULT TABLESPACE TAB_CS\r\nTEMPORARY TABLESPACE TEMP\r\nACCOUNT UNLOCK\r\nQUOTA UNLIMITED ON TAB_CS;\r\n\r\nGRANT CONNECT TO MyUser;\r\nGRANT RESOURCE TO MyUser;\r\nGRANT DBA\u00a0 TO MyUser;\r\n\r\n<\/pre>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;-<br \/>\nImport the DUMP<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;-<br \/>\nCopy the dump file to c:\\TheDumpFIle.dump<\/p>\n<p>Open windows command prompt (Start\/Run\/cmd) and run:<\/p>\n<pre lang=\"bash\">C:\\oraclexe\\app\\oracle\\product\\10.2.0\\server\\BIN\\imp.exe M260\/M260 file=TheDumpFIle.dump full=yes<\/pre>\n<p>Import should run without any warning<\/p>\n<p>Verify that everything is OK ussing an Oracle client connect as MyUservia SQL developper and check tables<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Import an Oracle dump to oracle XE in 3 steps: Create a directory to contain a new tablespace Create a dedicated tablespace and user that reflects the name of the ones used to export Import the dump into this new tablespace Detailled instructions &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; Create a directory for Data (tablespace) &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; mkdir C:\\myDataFiles &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; Create &hellip; <a href=\"https:\/\/le-moulin-de-verre.com\/fieldnotes\/?p=85\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Import dump in Oracle XE&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[14],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5WcEf-1n","_links":{"self":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/posts\/85"}],"collection":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=85"}],"version-history":[{"count":1,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/posts\/85\/revisions"}],"predecessor-version":[{"id":142,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=\/wp\/v2\/posts\/85\/revisions\/142"}],"wp:attachment":[{"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=85"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=85"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/le-moulin-de-verre.com\/fieldnotes\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=85"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}