It is not easy to find the correct way to execute expdp command in console. There are some steps before you execute expdp command.<\/p>\n\n\n\n
First you have to create a directory on the computer where Oracle DB is, where you will put the dump files than you have to grant a schema the rights to create a directory.<\/p>\n\n\n\n
Execute this command in SQL Developer or in sqlplus:<\/p>\n\n\n\n
grant create any directory to myschema;<\/strong><\/p>\n\n\n\n Replace myschema<\/strong> with your schema name.<\/p>\n\n\n\n than when you are connected in the shema myschema<\/strong> create the directory: <\/p>\n\n\n\n CREATE DIRECTORY DB_DUMP as ‘\/path\/to\/my-dump-directory’;<\/strong><\/p>\n\n\n\n than open console on the computer with the Oracle DB and execute:<\/p>\n\n\n\n expdp “‘myshema<\/strong> \/PASSWORD@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname)(Port=portname))(CONNECT_DATA=(SID=SID_name)))'” DIRECTORY=DB_DUMP REUSE_DUMPFILES=YES DUMPFILE=dump-XX-XX-2022.dmp LOGFILE=dump.log schemas=myshema<\/strong><\/strong><\/strong><\/p>\n\n\n\n You have to replace in command the myshema<\/strong><\/strong><\/strong> with your schema name, the password with the correct password, the hostname, portname, SID_name, DIRECTORY name if other, dumpfile name, logfile name.<\/p>\n\n\n\n I could not find in Google the correct syntax for expdp<\/strong> command and how to make Oracle dump. <\/p>\n","protected":false},"excerpt":{"rendered":" It is not easy to find the correct way to execute expdp command in console. There are some steps before you execute expdp command. First you have to create a directory on the computer where Oracle DB is, where you will put the dump files than you have to grant a schema the rights to […]<\/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-oracle-"],"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":"\u0411\u0430\u043d\u043a\u0442\u0435\u0440\u0433\u0435 \u049b\u0430\u043b\u0430\u0439 \u049b\u043e\u043b \u049b\u043e\u044e\u0493\u0430 \u0431\u043e\u043b\u0430\u0434\u044b. \u0410\u043f\u043f\u043b\u0435\u0442\u0442\u0435\u0440\u0434\u0435 \u043f\u0430\u0439\u0434\u0430\u043b\u0430\u043d\u0443 \u04af\u0448\u0456\u043d \u0431\u0430\u043d\u043a\u0430\u043b\u0430\u0440\u0493\u0430 \u049b\u043e\u043b \u049b\u043e\u044e.","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 "Java"","block_context":{"text":"Java","link":"https:\/\/vkrastev1blog.com\/category\/java\/"},"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":"Ubuntu \u0436\u04af\u0439\u0435\u0441\u0456\u043d\u0434\u0435 \u0441\u044b\u043d\u0430\u049b \u0434\u0438\u0441\u043a\u0456\u0441\u0456\u043d \u043e\u0440\u043d\u0430\u0442\u0443 \u0436\u04d9\u043d\u0435 \u0493\u0430\u043b\u0430\u043c\u0434\u044b\u049b \u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0439\u0434\u0456 \u049b\u043e\u0441\u0443 \u04d9\u0434\u0456\u0441\u0456","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 "\u0411\u0430\u0441\u049b\u0430\u043b\u0430\u0440"","block_context":{"text":"\u0411\u0430\u0441\u049b\u0430\u043b\u0430\u0440","link":"https:\/\/vkrastev1blog.com\/category\/%d0%b1%d0%b0%d1%81%d2%9b%d0%b0%d0%bb%d0%b0%d1%80\/"},"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 \u049b\u0430\u0439\u0442\u0430 \u0436\u0430\u0437\u0443 \u0440\u0435\u0436\u0438\u043c\u0456 – \u043a\u0430\u0442\u0430\u043b\u043e\u0433\u0442\u044b \u049b\u0430\u0439\u0442\u0430 \u0436\u0430\u0437\u0443 \u0435\u0440\u0435\u0436\u0435\u0441\u0456\u043d\u0435\u043d \u049b\u0430\u043b\u0430\u0439 \u0448\u044b\u0493\u0430\u0440\u0443\u0493\u0430 \u0431\u043e\u043b\u0430\u0434\u044b","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 "\u0411\u0430\u0441\u049b\u0430\u043b\u0430\u0440"","block_context":{"text":"\u0411\u0430\u0441\u049b\u0430\u043b\u0430\u0440","link":"https:\/\/vkrastev1blog.com\/category\/%d0%b1%d0%b0%d1%81%d2%9b%d0%b0%d0%bb%d0%b0%d1%80\/"},"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":"Solr 8 \u0436\u04af\u0439\u0435\u0441\u0456\u043d Windows \u0436\u04af\u0439\u0435\u0441\u0456\u043d\u0434\u0435 Service \u0440\u0435\u0442\u0456\u043d\u0434\u0435 \u043e\u0440\u043d\u0430\u0442\u044b\u04a3\u044b\u0437","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 "\u0411\u0430\u0441\u049b\u0430\u043b\u0430\u0440"","block_context":{"text":"\u0411\u0430\u0441\u049b\u0430\u043b\u0430\u0440","link":"https:\/\/vkrastev1blog.com\/category\/%d0%b1%d0%b0%d1%81%d2%9b%d0%b0%d0%bb%d0%b0%d1%80\/"},"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 \u0436\u04af\u0439\u0435\u0441\u0456\u043d\u0434\u0435 \u0445\u043e\u0441\u0442\u0442\u044b\u04a3 IP \u043c\u0435\u043a\u0435\u043d\u0436\u0430\u0439\u044b\u043d \u043a\u04e9\u0440\u0441\u0435\u0442\u0456\u04a3\u0456\u0437","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 "\u0411\u0430\u0441\u049b\u0430\u043b\u0430\u0440"","block_context":{"text":"\u0411\u0430\u0441\u049b\u0430\u043b\u0430\u0440","link":"https:\/\/vkrastev1blog.com\/category\/%d0%b1%d0%b0%d1%81%d2%9b%d0%b0%d0%bb%d0%b0%d1%80\/"},"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 \u0436\u04af\u0439\u0435\u0441\u0456\u043d\u0434\u0435 \u0435\u04a3 \u0441\u043e\u04a3\u0493\u044b NVIDIA \u0434\u0440\u0430\u0439\u0432\u0435\u0440\u0456\u043d \u049b\u0430\u043b\u0430\u0439 \u043e\u0440\u043d\u0430\u0442\u0443\u0493\u0430 \u0431\u043e\u043b\u0430\u0434\u044b","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 "\u0411\u0430\u0441\u049b\u0430\u043b\u0430\u0440"","block_context":{"text":"\u0411\u0430\u0441\u049b\u0430\u043b\u0430\u0440","link":"https:\/\/vkrastev1blog.com\/category\/%d0%b1%d0%b0%d1%81%d2%9b%d0%b0%d0%bb%d0%b0%d1%80\/"},"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}]}}