<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[goeprint的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/goeprint</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; goeprint]]></copyright><item><title><![CDATA[（全）数据泵的导入导出]]></title><link>https://blog.youkuaiyun.com/goeprint/article/details/121211011</link><guid>https://blog.youkuaiyun.com/goeprint/article/details/121211011</guid><author>goeprint</author><pubDate>Mon, 08 Nov 2021 16:42:27 +0800</pubDate><description><![CDATA[第一步，确定导出的路径（如浏览器的下载路径），在数据库建立路径



建立目录:/DATA/dump-——-路径

CREATE DIRECTORY dump as '/DATA/dump';

给路径赋权，读、写

GRANT READ,WIRTE DIRECTORY dump TO scott;(不能给自己赋权)

dump :路径名，自我发挥

/DATA/dump：选定的导出路径



第二步，导出语句

expdpscott/tiger DIRECTORY=dump DUMPFILE=dept..]]></description><category></category></item></channel></rss>