Oracle 11g export and import
a. Export:
sqlplus:
1. conn system/pass@xe as sysdba
2. create directory dump as 'c:\dump';
3. grant read,write on directory dump to public;
cmd:
expdp system/pass@xe schemas=trunk dumpfile
原创
2016-05-12 14:04:46 ·
342 阅读 ·
0 评论