\u5728\u63a7\u5236\u53f0\u4e2d\u627e\u5230\u57f7\u884c expdp \u547d\u4ee4\u7684\u6b63\u78ba\u65b9\u6cd5\u4e26\u4e0d\u5bb9\u6613\u3002\u57f7\u884c expdp \u6307\u4ee4\u4e4b\u524d\u6709\u4e00\u4e9b\u6b65\u9a5f\u3002<\/p>\n\n\n\n
\u9996\u5148\uff0c\u60a8\u5fc5\u9808\u5728 Oracle DB \u6240\u5728\u7684\u96fb\u8166\u4e0a\u5efa\u7acb\u76ee\u9304\uff0c\u60a8\u5c07\u5728\u5176\u4e2d\u653e\u7f6e\u8f49\u5132\u6587\u4ef6\uff0c\u7136\u5f8c\u60a8\u5fc5\u9808\u6388\u4e88\u6a21\u5f0f\u5efa\u7acb\u76ee\u9304\u7684\u6b0a\u9650\u3002<\/p>\n\n\n\n
\u5728 SQL Developer \u6216 sqlplus \u4e2d\u57f7\u884c\u6b64\u6307\u4ee4\uff1a<\/p>\n\n\n\n
\u6388\u4e88 myschema \u5efa\u7acb\u4efb\u4f55\u76ee\u9304\uff1b<\/strong><\/p>\n\n\n\n \u4ee3\u66ff \u6211\u7684\u5716\u5f0f<\/strong> \u8207\u60a8\u7684\u67b6\u69cb\u540d\u7a31\u3002<\/p>\n\n\n\n \u8207\u60a8\u5728\u67b6\u69cb\u4e2d\u9023\u63a5\u6642\u76f8\u6bd4 \u6211\u7684\u5716\u5f0f<\/strong> \u5efa\u7acb\u76ee\u9304\uff1a <\/p>\n\n\n\n \u5efa\u7acb\u76ee\u9304 DB_DUMP \u4f5c\u70ba\u201c\/path\/to\/my-dump-directory\u201d\uff1b<\/strong><\/p>\n\n\n\n \u6bd4\u5728\u88dd\u6709 Oracle DB \u7684\u96fb\u8166\u4e0a\u958b\u555f\u63a7\u5236\u53f0\u4e26\u57f7\u884c\uff1a<\/p>\n\n\n\n \u8868\u9054\u5f0f ”\u6211\u7684\u5716\u5f0f<\/strong> \/PASSWORD@(DESCRIPTION=(\u5730\u5740=(\u5354\u5b9a=TCP)(\u4e3b\u6a5f=\u4e3b\u6a5f\u540d\u7a31)(\u9023\u63a5\u57e0=\u9023\u63a5\u57e0\u540d\u7a31))(CONNECT_DATA=(SID=SID_name)))'” DIRECTORY=DB_DUMP REUSE_DUMPFILES=YES DUMPFILE=dump-XX-XX-2002.\u6211\u7684\u5716\u5f0f<\/strong><\/strong><\/strong><\/p>\n\n\n\n \u60a8\u5fc5\u9808\u5728\u547d\u4ee4\u4e2d\u66ff\u63db \u6211\u7684\u5716\u5f0f<\/strong><\/strong><\/strong> \u5305\u542b\u60a8\u7684\u67b6\u69cb\u540d\u7a31\u3001\u6b63\u78ba\u5bc6\u78bc\u7684\u5bc6\u78bc\u3001\u4e3b\u6a5f\u540d\u7a31\u3001\u9023\u63a5\u57e0\u540d\u7a31\u3001SID_name\u3001\u76ee\u9304\u540d\u7a31\uff08\u5982\u679c\u662f\u5176\u4ed6\u540d\u7a31\uff09\u3001\u8f49\u5132\u6a94\u6848\u540d\u7a31\u3001\u65e5\u8a8c\u6a94\u6848\u540d\u7a31\u3002<\/p>\n\n\n\n \u6211\u5728 Google \u4e2d\u627e\u4e0d\u5230\u6b63\u78ba\u7684\u8a9e\u6cd5 \u6307\u6570<\/strong> \u547d\u4ee4\u4ee5\u53ca\u5982\u4f55\u9032\u884c Oracle \u8f49\u5132\u3002 <\/p>\n","protected":false},"excerpt":{"rendered":" \u5728\u63a7\u5236\u53f0\u4e2d\u627e\u5230\u57f7\u884c expdp \u547d\u4ee4\u7684\u6b63\u78ba\u65b9\u6cd5\u4e26\u4e0d\u5bb9\u6613\u3002 […]<\/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-console-database-dump","tag-database-dump","tag-expdp","tag-oracle-dump"],"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":"\u5982\u4f55\u7b7e\u7f72\u7f50\u5b50\u3002\u7b7e\u7f72\u7528\u4e8e Applet \u7684 Jars\u3002","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 "\u722a\u54c7"","block_context":{"text":"\u722a\u54c7","link":"https:\/\/vkrastev1blog.com\/category\/%e7%88%aa%e5%93%87\/"},"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":"\u5982\u4f55\u5728 Ubuntu \u4e0a\u5b89\u88c5 testdisk \u5e76\u6dfb\u52a0 Universe \u5b58\u50a8\u5e93","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 "\u5176\u4ed6\u7684"","block_context":{"text":"\u5176\u4ed6\u7684","link":"https:\/\/vkrastev1blog.com\/category\/%e5%85%b6%e4%bb%96%e7%9a%84\/"},"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\u91cd\u5199\u6a21\u5f0f–\u5982\u4f55\u4ece\u91cd\u5199\u89c4\u5219\u4e2d\u6392\u9664\u76ee\u5f55","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 "\u5176\u4ed6\u7684"","block_context":{"text":"\u5176\u4ed6\u7684","link":"https:\/\/vkrastev1blog.com\/category\/%e5%85%b6%e4%bb%96%e7%9a%84\/"},"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\u4e0b\u5b89\u88ddSolr 8\u4f5c\u70ba\u670d\u52d9","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 "\u5176\u4ed6\u7684"","block_context":{"text":"\u5176\u4ed6\u7684","link":"https:\/\/vkrastev1blog.com\/category\/%e5%85%b6%e4%bb%96%e7%9a%84\/"},"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":"\u5728 Linux CentOS \u4e2d\u986f\u793a\u4e3b\u6a5f IP \u4f4d\u5740","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 "\u5176\u4ed6\u7684"","block_context":{"text":"\u5176\u4ed6\u7684","link":"https:\/\/vkrastev1blog.com\/category\/%e5%85%b6%e4%bb%96%e7%9a%84\/"},"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":"\u5982\u4f55\u5728 Ubuntu \u4e0a\u5b89\u88c5\u6700\u65b0\u7684 NVIDIA \u9a71\u52a8\u7a0b\u5e8f","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 "\u5176\u4ed6\u7684"","block_context":{"text":"\u5176\u4ed6\u7684","link":"https:\/\/vkrastev1blog.com\/category\/%e5%85%b6%e4%bb%96%e7%9a%84\/"},"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}]}}