5.创建导入导出目录
create or replace directory dump_dir as ‘/oracle/admin/pbossdb/dpdump’;
6.给用户赋予目录操作权限
Grant read,write on directory dump_dir to 实例名;
expdp username/passwd@*** tables=gumservicebase directory=/home/oracle/dump_dir dumpfile=gumservicebase0228.dmp logfile=gumservicebase0228.log;
expdp username/passwd@*** schemas=jsycldb directory=/home/oracle/dumpdir dumpfile =jsycldb_130827.dmp logfile=jsycldb_0827.log;
=================================================一下成功了!
impdp username/passwd@*** directory=dump_dir dumpfile=gum0929.dmp TRANSFORM=segment_attributes:n REMAP_SCHEMA=:
==================================================根据表名查询表空间的名称(表名称必须大写)
select tablespace_name from user_tables where table_name =‘表名’;
===========================================================================================排除大数据表的导出
expdp username/passwd directory=expdp_shuju exclude=TABLE:“IN (‘FM_ALARM_HISTORY’,‘PON_ONUPTP_TEMP’,‘TRAILROUTETEMP’,‘RM_TRANS_PORT_BAK’,‘PON_ONU_TEMP’,‘PON_ONU_BEIFEN。。。。’)” dumpfile =e2egum_140910.dmp logfile=e2egum_140910.log;
exp username/passwd@*** file=fmalarm0327.dmp tables=“(fm_alarm)”
imp username/passwd@*** file=/home/oracle/dumpdir/fmalarm0327.dmp fromuser=gumdb2fj touser=gumdbfj ignore=y