Linux环境oracle导入导出

在linux环境下需要切换到oracle用户下

su - oracle

sqlplus / as sysdba

--创建表空间EBSPACE
Create tablespace EBSPACE datafile '/u02/oradata/EBSPACE.dbf' size 500M autoextend on maxsize unlimited;

--创建用户 SCOTT
CREATE USER SCOTT PROFILE "DEFAULT" 
    IDENTIFIED BY SCOTT DEFAULT TABLESPACE "EBSPACE" 
    QUOTA UNLIMITED 
    ON "EBSPACE" 
    ACCOUNT UNLOCK;
GRANT "CONNECT" TO SCOTT;
GRANT  create    ANY LIBRARY TO SCOTT;
GRANT  create    ANY PROCEDURE TO SCOTT;
GRANT  create    ANY SEQUENCE TO SCOTT;
grant imp_full_database to SCOTT;

--创建虚拟路径
create directory db_bak as '/home/db_bak'; 

--directory授权
Grant read,write on directory db_bak to SCOTT;

--退出oracle
quit;

-导出数据
expdp SCOTT/SCOTT@orcl directory=db_bak version=11.0 dumpfile = 20181226.dmp

--导入数据
impdp SCOTT/SCOTT@orcl directory=db_bak dumpfile = 20181226.dmp remap_schema=test:SCOTT remap_tablespace=SPACE:EBSPACE

导入导出的参数意思，请参考https://blog.csdn.net/hhlxxt/article/details/85258552