{"id":174,"date":"2022-02-08T14:03:37","date_gmt":"2022-02-08T14:03:37","guid":{"rendered":"https:\/\/vkrastev1blog.com\/?p=174"},"modified":"2026-10-19T12:27:48","modified_gmt":"2026-10-19T12:27:48","slug":"create-dump-from-oracle-schema-in-console-in-linux","status":"publish","type":"post","link":"https:\/\/vkrastev1blog.com\/2022\/02\/08\/create-dump-from-oracle-schema-in-console-in-linux\/","title":{"rendered":"Luo vedos Oracle-skeemasta konsolissa Linuxissa"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Ei ole helppoa l\u00f6yt\u00e4\u00e4 oikeaa tapaa suorittaa expdp-komento konsolissa. On joitakin vaiheita ennen expdp-komennon suorittamista.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ensin sinun on luotava hakemisto tietokoneelle, jossa Oracle DB on, johon sijoitat vedostiedostot ja sitten sinun on my\u00f6nnett\u00e4v\u00e4 skeemalle oikeudet hakemiston luomiseen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Suorita t\u00e4m\u00e4 komento SQL Developerissa tai sqlplusissa:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>my\u00f6nn\u00e4 luoda mik\u00e4 tahansa hakemisto myschemalle;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Korvata <strong>myschema<\/strong> skeemosi nimell\u00e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">kuin silloin, kun olet yhteydess\u00e4 skeemaan <strong>myschema<\/strong> luo hakemisto: <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>LUO HAKEMISTO DB_DUMP nimell\u00e4 &#8216;\/polku\/oma-vedoshakemistoon&#8217;;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">kuin avaa konsoli tietokoneessa Oracle DB:ll\u00e4 ja suorita:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>expdp &#8220;&#8216;<strong>myschema<\/strong> \/SALASANA@(DESCRIPTION=(OSOITE=(PROTOKOLI=TCP)(Is\u00e4nt\u00e4=is\u00e4nt\u00e4nimi)(Portti=portin nimi))(CONNECT_DATA=(SID=SID_nimi)))'&#8221; DIRECTORY=DB_DUMP REUSE_DUMPFILES=YES DUMPFILE=&#8221;schema=&#8221;dump-XX-XXLEDMP2.<strong><strong>myschema<\/strong><\/strong><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sinun on korvattava komennolla <strong><strong><strong>myschema<\/strong><\/strong><\/strong> skeeman nimell\u00e4, salasanalla oikealla salasanalla, is\u00e4nt\u00e4nimi, porttinimi, SID_nimi, HAKEMISTO-nimi, jos muu, dumptiedoston nimi, lokitiedoston nimi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En l\u00f6yt\u00e4nyt Googlesta oikeaa syntaksia t\u00e4lle <strong>expdp<\/strong> komento ja kuinka saada Oracle dump. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ei ole svetka uttaia oikea tapaa expdp-komento konsolissa. On some expdp-komennon p\u00e4\u00e4hita ennen expdp-komennon p\u00e4\u00e4mista. Ensin sinun on luotava ekhimsi kontokteelle, jossa Oracle DB on, johon ruijitat vedosfilettot ja sitten sinun on skeemalle ikeemalle oikeud ekhimsiyon luomiseen. Run this comment SQL Developerissa tai sqlplusissa: t\u00e4\u00e4\u00e4 luoda \u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4 \u00e4\u00e4\u00e4\u00e4\u00e4 Korvata myschema skeemosi kiraman. kuin [&hellip;]<\/p>\n","protected":false},"author":65283547,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[559],"tags":[729567818,27737053,937829,100496292],"class_list":["post-174","post","type-post","status-publish","format-standard","hentry","category-muut","tag-konsolin-tietokannan-vedos","tag-tietokannan-vedos","tag-expdp","tag-oraakkelin-kaatopaikka"],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4CoHV-2O","jetpack-related-posts":[],"jetpack_likes_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/users\/65283547"}],"replies":[{"embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/comments?post=174"}],"version-history":[{"count":7,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/174\/revisions"}],"predecessor-version":[{"id":2826,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/174\/revisions\/2826"}],"wp:attachment":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/media?parent=174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/categories?post=174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/tags?post=174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}