导库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