å¨åæå¡å¨ï¼WINDOWNæå¡å¨ï¼ä¸Dçå建ä¸ä¸ªDataBakç®å½
sqlplus sys/oracle@orcl as sysdba --
å建æ°æ®æ³µç®å½ Create directory dp as 'd:\DataBak';
--ææç¨æ· Grant read,write on directory dp to system; grant exp_full_database to SYSTEM; grant imp_full_database to SYSTEM;
--设置为ä¸éå¶å¤§å°å Alter System Set sec_case_sensitive_logon = false scope=both;
--设置为å¯ä»¥å¯¼åºç©ºè¡¨ Alter System Set deferred_segment_creation=false scope=both;
--设置为ä¸éå¶å¯ç ææ Alter Profile Default Limit Password_Life_Time Unlimited;
--å¨åæå¡å¨ä¸å¯¼åºæ°æ®æ³µæ°æ® expdp 'sys/oracle as sysdba' DUMPFILE=expdp_full_%U.dmp DIRECTORY=dp LOGFILE=expdpfull.log FULL=y parallel=4 -
温馨提示:答案为网友推荐,仅供参考