oracle 数据泵使用

docker  cp  atp20200701123941.dmp   oracle11g:/home/oracle/app/oracle/admin/helowin/dpdump/
docker  cp  netoffice20200701123941.dmp  oracle11g:/home/oracle/app/oracle/admin/helowin/dpdump/
docker  cp  oabase20200602.dmp   oracle11g:/home/oracle/app/oracle/admin/helowin/dpdump/
docker  cp  office20200602.dmp   oracle11g:/home/oracle/app/oracle/admin/helowin/dpdump/
docker  cp  UPP20200602.dmp   oracle11g:/home/oracle/app/oracle/admin/helowin/dpdump/
docker  cp  UPURCHASE20200602.dmp   oracle11g:/home/oracle/app/oracle/admin/helowin/dpdump/
docker  cp  zw_gwxt20200527.dmp   oracle11g:/home/oracle/app/oracle/admin/helowin/dpdump


//查询所有表
select * from dba_directories


//导入
impdp   sys /sys  as sysdba    table_exists=replace   directory=DATA_PUMP_DIR  dumpfile=oabase20200602.dmp


//导出
expdp sys/sys@*.*.*.*/orcl schemas=dbuser dumpfile=expdp.dmp directory=data_dir logfile=expdp.log

//创建表空间
CREATE TABLESPACE "ATP" DATAFILE '/home/oracle/app/oracle/oradata/helowin/atp.dbf' SIZE 5242880 AUTOEXTEND ON NEXT 1310720 MAXSIZE UNLIMITED

//创建用户
CREATE USER "OABASE" IDENTIFIED BY "1" DEFAULT TABLESPACE "OABASE"

create or replace directory DATA_PUMP_DIR as '/data/dumpdir';

/home/oracle/app/oracle/admin/helowin/dpdump/

create or replace directory DATA_PUMP_DIR as '/home/oracle/app/oracle/admin/helowin/dpdump/';