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
-- 为表空间增加数据文件
alter tablespace users add datafile '+DATA/gtyun/datafile/users04.dbf' size 1024m autoextend on next 512m maxsize unlimited;
-- 查询所有表
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"
-- 授权
grant connect,resource,dba to OABASE;
grant connect, resource, dba to OABASE;
GRANT CREATE DATABASE LINK, ALTER DATABASE LINK, CREATE JOB, CREATE ANY TABLE, ALTER ANY TABLE, DELETE ANY TABLE, DROP ANY TABLE, SELECT ANY TABLE, CREATE ANY TRIGGER, ALTER ANY TRIGGER, DROP ANY TRIGGER, CREATE ANY TYPE, DROP ANY TYPE, CREATE ANY VIEW, DROP ANY VIEW, SYSDBA TO "NTEOFFICE_TOOL" WITH ADMIN OPTION;
-- 修改数据库文件夹
create or replace directory DATA_PUMP_DIR as '/home/oracle/app/oracle/admin/helowin/dpdump/';
-- 创建dblink
create public database link OMMOBILE78
connect to ommobile identified by "ommobile"
using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = *.*.*.* )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = yztdb) ) )'
--删除dblink
drop public database link OMMOBILE78;
