导库expdp、impdp

导库expdp、impdp

创建逻辑目录

 create or replace directory dp_dir1  as '/app/oracle/admin/maptest/dpdump/';

查询创建逻辑目录

 select * from dba_directories;

以sys管理员赋权

grant read,write on directory dp_dir1 to gisapp;

exp–197

 expdp gisapp/sde12talkweb@orcl directory=dp_dir1 dumpfile=GISAPP_20200802.dmp 

imp–198，导入指定双方用户及表空间

 impdp gisapp/Sde12_talkweb@132.98.16.198:1521/maptest  dumpfile=GISAPP_20200802.dmp DIRECTORY=dp_dir1  remap_schema=gisapp:gisapp remap_tablespace=GISAPP_TABSPACE:TBS_DATA 

exp指定表名

 expdp sde/sde@192.168.124.21:1521/gdgeo  dumpfile=sde.dmp DIRECTORY=dp_dir1 tables=sde.HT_AUDIT_RESOURCES,sde.HT_AUDIT_WORKORDER,sde.HT_BUS_FEEDBACK