oracle 备份

1.创建虚拟目录，映射到本地

create directory beifen as 'd:/beifen';

查看所有目录

SELECT * FROM dba_directories;

2.全库备份

expdp system/123456@127.0.0.1/orcl directory=beifen dumpfile=ly.dmp full=y  logfile=expdp.log;

一个错误

解决的办法就是将EXEMPT ACCESS POLICY这个权限赋给system用户：

sqlplus /nolog
conn / as sysdba
GRANT EXEMPT ACCESS POLICY TO system;

成功！