分享EAS8.5demo账套的用户名和表空间及导入方式

demo账套的用户：NEWDB850BC   表空间：EAS_D_NEWDB850BC_STANDARD    EAS_T_NEWDB850BC_TEMP

***********************************************************************************************************************************************
创建表空间及用户：

create temporary tablespace EAS_T_NEWDB850BC_TEMP tempfile '/oracle/app/oradata/orcl/EAS_T_NEWDB850BC_TEMP.dbf' size 100m  autoextend on next 50m maxsize UNLIMITED extent management local;

create tablespace EAS_D_NEWDB850BC_TEMP2 datafile '/oracle/app/oradata/orcl/EAS_D_NEWDB850BC_TEMP2.dbf' size 100m autoextend on  next 50m maxsize UNLIMITED extent management local;

create tablespace EAS_D_NEWDB850BC_INDEX datafile '/oracle/app/oradata/orcl/EAS_D_NEWDB850BC_INDEX.dbf' size 100m autoextend on  next 50m maxsize UNLIMITED extent management local;

create tablespace EAS_D_NEWDB850BC_STANDARD datafile '/oracle/app/oradata/orcl/EAS_D_NEWDB850BC_STANDARD.dbf' size 100m  autoextend on MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

create user NEWDB850BC IDENTIFIED BY 123456 DEFAULT TABLESPACE EAS_D_NEWDB850BC_STANDARD TEMPORARY TABLESPACE  EAS_T_NEWDB850BC_TEMP ACCOUNT UNLOCK;

create or replace directory dmpdir as '/oracle/backup';

GRANT CONNECT,RESOURCE,DBA TO NEWDB850BC;

grant read,write on directory dmpdir to NEWDB850BC;

导入测试数据：

impdp NEWDB850BC/123456 directory=dmpdir dumpfile=NEWDB850BC.DMP table_exists_action=replace job_name=NEWDB850BC_impdp exclude=statistics LOGFILE=impdpNEWDB850BC.log