windows下使用expdp导出备份小案例
impdp bsrun/password directory=data_pump_dir
DUMPFILE=HIS201504156.DMP schemas=bsrun;
需要知道的几个概念 :
1. DIRECTORY
指定转储文件和日志文件所在的目录
DIRECTORY=directory_object
Directory_object用于指定目录对象名称.需要注意,目录对象是使用CREATE
DIRECTORY语句建立的对象,而不是OS目录
Expdp scott/tiger DIRECTORY= DMP DUMPFILE=a.dump
create or replace directory dmp
as ‘d:/dmp’
expdp zftang/zftang@zftang directory=dmp dumpfile=test.dmp
content=metadata_only
================================================================
SQL> select * from dba_direc