{"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":"Linux \u092e\u0947\u0902 \u0915\u0902\u0938\u094b\u0932 \u092e\u0947\u0902 Oracle \u0938\u094d\u0915\u0940\u092e\u093e \u0938\u0947 \u0921\u0902\u092a \u092c\u0928\u093e\u090f\u0902"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u0915\u0902\u0938\u094b\u0932 \u092e\u0947\u0902 expdp \u0915\u092e\u093e\u0902\u0921 \u0928\u093f\u0937\u094d\u092a\u093e\u0926\u093f\u0924 \u0915\u0930\u0928\u0947 \u0915\u093e \u0938\u0939\u0940 \u0924\u0930\u0940\u0915\u093e \u0916\u094b\u091c\u0928\u093e \u0906\u0938\u093e\u0928 \u0928\u0939\u0940\u0902 \u0939\u0948\u0964 \u090f\u0915\u094d\u0938\u092a\u0940\u0921\u0940\u092a\u0940 \u0915\u092e\u093e\u0902\u0921 \u0928\u093f\u0937\u094d\u092a\u093e\u0926\u093f\u0924 \u0915\u0930\u0928\u0947 \u0938\u0947 \u092a\u0939\u0932\u0947 \u0915\u0941\u091b \u091a\u0930\u0923 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0906\u092a\u0915\u094b \u0915\u0902\u092a\u094d\u092f\u0942\u091f\u0930 \u092a\u0930 \u090f\u0915 \u0928\u093f\u0930\u094d\u0926\u0947\u0936\u093f\u0915\u093e \u092c\u0928\u093e\u0928\u0940 \u0939\u094b\u0917\u0940 \u091c\u0939\u093e\u0902 Oracle DB \u0939\u0948, \u091c\u0939\u093e\u0902 \u0906\u092a \u0921\u0902\u092a \u092b\u093c\u093e\u0907\u0932\u0947\u0902 \u0921\u093e\u0932\u0947\u0902\u0917\u0947, \u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b \u090f\u0915 \u0938\u094d\u0915\u0940\u092e\u093e \u0915\u094b \u0928\u093f\u0930\u094d\u0926\u0947\u0936\u093f\u0915\u093e \u092c\u0928\u093e\u0928\u0947 \u0915\u093e \u0905\u0927\u093f\u0915\u093e\u0930 \u0926\u0947\u0928\u093e \u0939\u094b\u0917\u093e\u0964<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL \u0921\u0947\u0935\u0932\u092a\u0930 \u092f\u093e sqlplus \u092e\u0947\u0902 \u0907\u0938 \u0915\u092e\u093e\u0902\u0921 \u0915\u094b \u0928\u093f\u0937\u094d\u092a\u093e\u0926\u093f\u0924 \u0915\u0930\u0947\u0902:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>myschema \u0915\u094b \u0915\u094b\u0908 \u092d\u0940 \u0928\u093f\u0930\u094d\u0926\u0947\u0936\u093f\u0915\u093e \u092c\u0928\u093e\u0928\u0947 \u0915\u0940 \u0905\u0928\u0941\u092e\u0924\u093f \u0926\u0947\u0902;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u092a\u094d\u0930\u0924\u093f\u0938\u094d\u0925\u093e\u092a\u093f\u0924 \u0915\u0930\u0947\u0902 <strong>myschema<\/strong> \u0906\u092a\u0915\u0947 \u0938\u094d\u0915\u0940\u092e\u093e \u0928\u093e\u092e \u0915\u0947 \u0938\u093e\u0925.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0924\u092c \u0938\u0947 \u091c\u092c \u0906\u092a \u0938\u094d\u0915\u0940\u092e\u093e \u092e\u0947\u0902 \u091c\u0941\u0921\u093c\u0947 \u0939\u0941\u090f \u0939\u0948\u0902 <strong>myschema<\/strong> \u0928\u093f\u0930\u094d\u0926\u0947\u0936\u093f\u0915\u093e \u092c\u0928\u093e\u090f\u0901: <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0928\u093f\u0930\u094d\u0926\u0947\u0936\u093f\u0915\u093e DB_DUMP \u0915\u094b &#8216;\/path\/to\/my-dump-directory&#8217; \u0915\u0947 \u0930\u0942\u092a \u092e\u0947\u0902 \u092c\u0928\u093e\u090f\u0901;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle DB \u0915\u0947 \u0938\u093e\u0925 \u0915\u0902\u092a\u094d\u092f\u0942\u091f\u0930 \u092a\u0930 \u0915\u0902\u0938\u094b\u0932 \u0916\u094b\u0932\u0947\u0902 \u0914\u0930 \u0928\u093f\u0937\u094d\u092a\u093e\u0926\u093f\u0924 \u0915\u0930\u0947\u0902:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u090f\u0915\u094d\u0938\u092a\u0940\u0921\u0940\u092a\u0940 &#8220;&#8216;<strong>myschema<\/strong> \/\u092a\u093e\u0938\u0935\u0930\u094d\u0921@(\u0935\u093f\u0935\u0930\u0923=(\u092a\u0924\u093e=(\u092a\u094d\u0930\u094b\u091f\u094b\u0915\u0949\u0932=\u091f\u0940\u0938\u0940\u092a\u0940)(\u0939\u094b\u0938\u094d\u091f=\u0939\u094b\u0938\u094d\u091f\u0928\u093e\u092e)(\u092a\u094b\u0930\u094d\u091f=\u092a\u094b\u0930\u094d\u091f\u0928\u093e\u092e))(CONNECT_DATA=(SID=SID_name)))&#8221; \u0928\u093f\u0930\u094d\u0926\u0947\u0936\u093f\u0915\u093e=DB_DUMP \u092a\u0941\u0928\u0903\u0909\u092a\u092f\u094b\u0917_DUMPFILES=\u0939\u093e\u0901 DUMPFILE=dump-XX-XX-2022.dmp LOGFILE=dump.log \u0938\u094d\u0915\u0940\u092e\u093e =<strong><strong>myschema<\/strong><\/strong><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0906\u092a\u0915\u094b \u0915\u092e\u093e\u0902\u0921 \u092e\u0947\u0902 \u092a\u094d\u0930\u0924\u093f\u0938\u094d\u0925\u093e\u092a\u093f\u0924 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e <strong><strong><strong>myschema<\/strong><\/strong><\/strong> \u0906\u092a\u0915\u0947 \u0938\u094d\u0915\u0940\u092e\u093e \u0928\u093e\u092e \u0915\u0947 \u0938\u093e\u0925, \u0938\u0939\u0940 \u092a\u093e\u0938\u0935\u0930\u094d\u0921 \u0935\u093e\u0932\u093e \u092a\u093e\u0938\u0935\u0930\u094d\u0921, \u0939\u094b\u0938\u094d\u091f\u0928\u093e\u092e, \u092a\u094b\u0930\u094d\u091f\u0928\u093e\u092e, SID_\u0928\u093e\u092e, \u092f\u0926\u093f \u0905\u0928\u094d\u092f \u0939\u094b \u0924\u094b \u0921\u093e\u092f\u0930\u0947\u0915\u094d\u091f\u094d\u0930\u0940 \u0928\u093e\u092e, \u0921\u0902\u092a\u092b\u093c\u093e\u0907\u0932 \u0928\u093e\u092e, \u0932\u0949\u0917\u092b\u093c\u093e\u0907\u0932 \u0928\u093e\u092e\u0964<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u092e\u0941\u091d\u0947 Google \u092e\u0947\u0902 \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0938\u0939\u0940 \u0935\u093e\u0915\u094d\u092f\u0935\u093f\u0928\u094d\u092f\u093e\u0938 \u0928\u0939\u0940\u0902 \u092e\u093f\u0932\u093e <strong>expdp<\/strong> \u0915\u092e\u093e\u0902\u0921 \u0914\u0930 Oracle \u0921\u0902\u092a \u0915\u0948\u0938\u0947 \u092c\u0928\u093e\u090f\u0902\u0964 <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0915\u0902\u0938\u094b\u0932 \u092e\u0947\u0902 expdp \u0915\u092e\u093e\u0902\u0921 \u0928\u093f\u0937\u094d\u092a\u093e\u0926\u093f\u0924 \u0915\u0930\u0928\u0947 \u0915\u093e \u0938\u0939\u0940 \u0924\u0930\u0940\u0915\u093e \u0916\u094b\u091c\u0928\u093e \u0906\u0938\u093e\u0928 \u0928\u0939\u0940\u0902 \u0939\u0948\u0964 \u090f\u0915\u094d\u0938\u092a\u0940\u0921\u0940\u092a\u0940 \u0915\u092e\u093e\u0902\u0921 \u0928\u093f\u0937\u094d\u092a\u093e\u0926\u093f\u0924 \u0915\u0930\u0928\u0947 \u0938\u0947 \u092a\u0939\u0932\u0947 \u0915\u0941\u091b \u091a\u0930\u0923 \u0939\u0948\u0902\u0964 \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0906\u092a\u0915\u094b \u0915\u0902\u092a\u094d\u092f\u0942\u091f\u0930 \u092a\u0930 \u090f\u0915 \u0928\u093f\u0930\u094d\u0926\u0947\u0936\u093f\u0915\u093e \u092c\u0928\u093e\u0928\u0940 \u0939\u094b\u0917\u0940 \u091c\u0939\u093e\u0902 Oracle DB \u0939\u0948, \u091c\u0939\u093e\u0902 \u0906\u092a \u0921\u0902\u092a \u092b\u093c\u093e\u0907\u0932\u0947\u0902 \u0921\u093e\u0932\u0947\u0902\u0917\u0947, \u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b \u090f\u0915 \u0938\u094d\u0915\u0940\u092e\u093e \u0915\u094b \u0928\u093f\u0930\u094d\u0926\u0947\u0936\u093f\u0915\u093e \u092c\u0928\u093e\u0928\u0947 \u0915\u093e \u0905\u0927\u093f\u0915\u093e\u0930 \u0926\u0947\u0928\u093e \u0939\u094b\u0917\u093e\u0964 SQL \u0921\u0947\u0935\u0932\u092a\u0930 \u092f\u093e [&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-559","tag-729567818","tag-27737053","tag-expdp","tag-100496292"],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4CoHV-2O","jetpack-related-posts":[{"id":47,"url":"https:\/\/vkrastev1blog.com\/2014\/05\/11\/how-to-sign-jars-signing-jars-for-use-in-applets\/","url_meta":{"origin":174,"position":0},"title":"\u091c\u093e\u0930 \u092a\u0930 \u0939\u0938\u094d\u0924\u093e\u0915\u094d\u0937\u0930 \u0915\u0948\u0938\u0947 \u0915\u0930\u0947\u0902. \u090f\u092a\u094d\u0932\u0947\u091f\u094d\u0938 \u092e\u0947\u0902 \u0909\u092a\u092f\u094b\u0917 \u0915\u0947 \u0932\u093f\u090f \u091c\u093e\u0930 \u092a\u0930 \u0939\u0938\u094d\u0924\u093e\u0915\u094d\u0937\u0930 \u0915\u0930\u0928\u093e\u0964","author":"vkrastev2014","date":"11.05.2014","format":false,"excerpt":"As the Browsers now want the Jars to be signed it happens oft that man have to sign a Jar himself. Here is a Manual how to sign a Jar. First you have to install Java SDK. http:\/\/www.oracle.com\/technetwork\/java\/javase\/downloads\/index.html?ssSourceSiteId=otnjp Install the JDK from the list for the envitonment you use. This\u2026","rel":"","context":"In &quot;\u091c\u093e\u0935\u093e&quot;","block_context":{"text":"\u091c\u093e\u0935\u093e","link":"https:\/\/vkrastev1blog.com\/category\/%e0%a4%9c%e0%a4%be%e0%a4%b5%e0%a4%be\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":21,"url":"https:\/\/vkrastev1blog.com\/2014\/05\/09\/how-to-install-testdisk-on-ubuntu-and-to-add-universe-repository\/","url_meta":{"origin":174,"position":1},"title":"\u0909\u092c\u0902\u091f\u0942 \u092a\u0930 \u091f\u0947\u0938\u094d\u091f\u0921\u093f\u0938\u094d\u0915 \u0915\u0948\u0938\u0947 \u0938\u094d\u0925\u093e\u092a\u093f\u0924 \u0915\u0930\u0947\u0902 \u0914\u0930 \u092f\u0942\u0928\u093f\u0935\u0930\u094d\u0938 \u0930\u093f\u092a\u0949\u091c\u093f\u091f\u0930\u0940 \u0915\u0948\u0938\u0947 \u091c\u094b\u0921\u093c\u0947\u0902","author":"vkrastev2014","date":"09.05.2014","format":false,"excerpt":"Execute the command in console in Ubuntu. The commands are made for \u00a0Ubuntu 12.04 LTS (Precise Pangolin). For your Ubuntu Version replace \"precise\" in these commands with your Ubuntu Version name: sudo add-apt-repository \"deb http:\/\/us.archive.ubuntu.com\/ubuntu precise universe miltiverse\" sudo add-apt-repository \"deb http:\/\/us.archive.ubuntu.com\/ubuntu precise-updates universe miltiverse\" sudo apt-get update sudo apt-get\u2026","rel":"","context":"In &quot;\u0905\u0928\u094d\u092f&quot;","block_context":{"text":"\u0905\u0928\u094d\u092f","link":"https:\/\/vkrastev1blog.com\/category\/%e0%a4%85%e0%a4%a8%e0%a5%8d%e0%a4%af\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":163,"url":"https:\/\/vkrastev1blog.com\/2022\/02\/01\/htaccess-rewrite-mode-how-to-exclude-directory-from-rewrite-rule\/","url_meta":{"origin":174,"position":2},"title":".htaccess \u092a\u0941\u0928\u0930\u094d\u0932\u0947\u0916\u0928 \u092e\u094b\u0921 &#8211; \u092a\u0941\u0928\u0930\u094d\u0932\u0947\u0916\u0928 \u0928\u093f\u092f\u092e \u0938\u0947 \u0928\u093f\u0930\u094d\u0926\u0947\u0936\u093f\u0915\u093e \u0915\u094b \u0915\u0948\u0938\u0947 \u092c\u093e\u0939\u0930 \u0930\u0916\u093e \u091c\u093e\u090f","author":"vkrastev2014","date":"01.02.2022","format":false,"excerpt":"119 Put a .htaccess file containing RewriteEngine Off In the folders you want to exclude from being rewritten by the rules in a .htaccess file that's higher up in the tree.\u00a0","rel":"","context":"In &quot;\u0905\u0928\u094d\u092f&quot;","block_context":{"text":"\u0905\u0928\u094d\u092f","link":"https:\/\/vkrastev1blog.com\/category\/%e0%a4%85%e0%a4%a8%e0%a5%8d%e0%a4%af\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":232,"url":"https:\/\/vkrastev1blog.com\/2022\/10\/31\/install-solr-8-under-windows-as-service\/","url_meta":{"origin":174,"position":3},"title":"Windows \u0915\u0947 \u0905\u0902\u0924\u0930\u094d\u0917\u0924 Solr 8 \u0915\u094b \u0938\u0947\u0935\u093e \u0915\u0947 \u0930\u0942\u092a \u092e\u0947\u0902 \u0938\u094d\u0925\u093e\u092a\u093f\u0924 \u0915\u0930\u0947\u0902","author":"vkrastev2014","date":"31.10.2022","format":false,"excerpt":"Here is short explained how to install Solr 8 as Windows service Download nssm from https:\/\/nssm.cc\/release\/nssm-2.24.zip and extract it to C:\\Program Files\\nssm Donwload Solr 8 from https:\/\/dlcdn.apache.org\/lucene\/solr\/8.11.2\/solr-8.11.2.zip and extract it to C:\\web\\solr Java Version 8 or later have to be istalled and JAVA_HOME environment variable set Create Windows Service solr8.\u2026","rel":"","context":"In &quot;\u0905\u0928\u094d\u092f&quot;","block_context":{"text":"\u0905\u0928\u094d\u092f","link":"https:\/\/vkrastev1blog.com\/category\/%e0%a4%85%e0%a4%a8%e0%a5%8d%e0%a4%af\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":213,"url":"https:\/\/vkrastev1blog.com\/2022\/04\/29\/show-host-ip-address-in-linux-centos\/","url_meta":{"origin":174,"position":4},"title":"Linux CentOS \u092e\u0947\u0902 \u0939\u094b\u0938\u094d\u091f IP \u092a\u0924\u093e \u0926\u093f\u0916\u093e\u090f\u0901","author":"vkrastev2014","date":"29.04.2022","format":false,"excerpt":"You can get the IP address by typing following command in console: hostname -i and it shows exactly only one real IP address of the host","rel":"","context":"In &quot;\u0905\u0928\u094d\u092f&quot;","block_context":{"text":"\u0905\u0928\u094d\u092f","link":"https:\/\/vkrastev1blog.com\/category\/%e0%a4%85%e0%a4%a8%e0%a5%8d%e0%a4%af\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":19,"url":"https:\/\/vkrastev1blog.com\/2014\/05\/09\/how-to-install-the-newest-nvidia-driver-on-ubuntu\/","url_meta":{"origin":174,"position":5},"title":"Ubuntu \u092a\u0930 \u0928\u0935\u0940\u0928\u0924\u092e NVIDIA \u0921\u094d\u0930\u093e\u0907\u0935\u0930 \u0915\u0948\u0938\u0947 \u0938\u094d\u0925\u093e\u092a\u093f\u0924 \u0915\u0930\u0947\u0902","author":"vkrastev2014","date":"09.05.2014","format":false,"excerpt":"Open console window and type following commands: -------------------------------------------------------------------------------------------------------------- sudo apt-add-repository ppa:ubuntu-x-swat sudo apt-get update sudo apt-get install nvidia-current --------------------------------------------------------------------------------------------------------------- And you have the newest Driver installed.","rel":"","context":"In &quot;\u0905\u0928\u094d\u092f&quot;","block_context":{"text":"\u0905\u0928\u094d\u092f","link":"https:\/\/vkrastev1blog.com\/category\/%e0%a4%85%e0%a4%a8%e0%a5%8d%e0%a4%af\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"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}]}}