{"id":1153,"date":"2018-02-18T12:07:08","date_gmt":"2018-02-18T04:07:08","guid":{"rendered":"http:\/\/www.821121.com\/?p=1153"},"modified":"2020-12-18T11:11:26","modified_gmt":"2020-12-18T03:11:26","slug":"oracle%e5%b7%a5%e5%85%b7%e4%b8%ad%ef%bc%88sqlplus%e3%80%81exp%e3%80%81expdp%ef%bc%89%e5%af%86%e7%a0%81%e9%81%87%e5%88%b0%e7%89%b9%e6%ae%8a%e5%ad%97%e7%ac%a6%e7%9a%84%e5%a4%84%e7%90%86%e6%96%b9","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1153","title":{"rendered":"oracle\u5de5\u5177\u4e2d\uff08sqlplus\u3001exp\u3001expdp\uff09\u5bc6\u7801\u9047\u5230\u7279\u6b8a\u5b57\u7b26\u7684\u5904\u7406\u65b9\u6cd5"},"content":{"rendered":"<p>&nbsp;<\/p>\n<table width=\"664\">\n<tbody>\n<tr>\n<td colspan=\"2\" width=\"127\">Linux\u5e73\u53f0<\/td>\n<td width=\"273\">sqlplus\u5de5\u5177<\/td>\n<td width=\"264\">\u6570\u636e\u6cf5\u5de5\u5177\uff08exp\u3001expdp\uff09<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"69\">\u666e\u901a\u7528\u6237<\/td>\n<td width=\"58\">\u65e0tns<\/td>\n<td width=\"273\">sqlplus 'whs\/\"w@h\\s\/0\"'<\/td>\n<td width=\"264\">expdp 'whs\/\"w@h\\s\/0\"'<\/td>\n<\/tr>\n<tr>\n<td width=\"58\">\u6709tns<\/td>\n<td width=\"273\">sqlplus 'whs\/\"w@h\\s\/0\"'@whs_db<\/td>\n<td width=\"264\">expdp 'whs\/\"w@h\\s\/0\"'@whs_db<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"3\" width=\"69\">sys\u7528\u6237<\/td>\n<td width=\"58\">\u65e0tns<\/td>\n<td width=\"273\">sqlplus \/ as sysdba<\/td>\n<td width=\"264\">expdp \\'\/ AS SYSDBA\\'<\/td>\n<\/tr>\n<tr>\n<td width=\"58\">\u6709tns<\/td>\n<td width=\"273\">sqlplus 'sys\/\"w@h\\s\/0\"'@whs_db as sysdba<\/td>\n<td width=\"264\">expdp \\''sys\/\"w@h\\s\/0\"'@whs_db as sysdba\\'<\/td>\n<\/tr>\n<tr>\n<td width=\"58\">\u6b63\u5e38\u5bc6\u7801<\/td>\n<td width=\"273\">sqlplus sys\/oracle@whs_db as sysdba<\/td>\n<td width=\"264\">expdp \\'sys\/oracle@whs_db as sysdba\\'<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<table width=\"664\">\n<tbody>\n<tr>\n<td colspan=\"2\" width=\"127\">Windows\u5e73\u53f0<\/td>\n<td width=\"273\">sqlplus\u5de5\u5177<\/td>\n<td width=\"264\">\u6570\u636e\u6cf5\u5de5\u5177\uff08exp\u3001expdp\uff09<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"4\" width=\"69\">\u666e\u901a\u7528\u6237<\/td>\n<td width=\"58\">\u65e0tns<\/td>\n<td width=\"273\">sqlplus whs\/\"\"\"w@h\\s\/0\"\"\"<\/td>\n<td width=\"264\">expdp whs\/\"\"\"w@h\\s\/0\"\"\"<\/td>\n<\/tr>\n<tr>\n<td width=\"58\"><\/td>\n<td width=\"273\">sqlplus whs\/\\\"w@h\\s\/0\\\"<\/td>\n<td width=\"264\">expdp whs\/\\\"w@h\\s\/0\\\"<\/td>\n<\/tr>\n<tr>\n<td width=\"58\">\u6709tns<\/td>\n<td width=\"273\">sqlplus whs\/\"\"\"w@h\\s\/0\"\"\"@whs_db<\/td>\n<td width=\"264\">expdp whs\/\"\"\"w@h\\s\/0\"\"\"@whs_db<\/td>\n<\/tr>\n<tr>\n<td width=\"58\"><\/td>\n<td width=\"273\">sqlplus whs\/\\\"w@h\\s\/0\\\"@whs_db<\/td>\n<td width=\"264\">expdp whs\/\\\"w@h\\s\/0\\\"@whs_db<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"4\" width=\"69\">sys\u7528\u6237<\/td>\n<td width=\"58\">\u65e0tns<\/td>\n<td width=\"273\">sqlplus \/ as sysdba<\/td>\n<td width=\"264\">expdp \\\"\/ as sysdba\\\"<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"58\">\u6709tns<\/td>\n<td colspan=\"2\" width=\"537\">sqlplus sys\/\"\"\"w@h\\s\/0\"\"\"@whs_db as sysdba<\/td>\n<\/tr>\n<tr>\n<td width=\"273\">sqlplus sys\/\\\"w@h\\s\/0\\\"@whs_db as sysdba<\/td>\n<td width=\"264\"><\/td>\n<\/tr>\n<tr>\n<td width=\"58\">\u6b63\u5e38\u5bc6\u7801<\/td>\n<td width=\"273\">sqlplus sys\/oracle@whs_db as sysdba<\/td>\n<td width=\"264\">expdp \\\"sys\/oracle@whs_db as sysdba\\\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Linux\u5e73\u53f0 sqlplus\u5de5\u5177 <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1153","post","type-post","status-publish","format-standard","hentry","category-34"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1153"}],"version-history":[{"count":3,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1153\/revisions"}],"predecessor-version":[{"id":1156,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1153\/revisions\/1156"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1153"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}