分享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

学习，标记下
学习
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
已成功加载/卸载了主表 "LIU"."SYS_IMPORT_FULL_02"
启动 "LIU"."SYS_IMPORT_FULL_02": liu/********@orcl directory=dmpdir dumpfile=NEWDB850BC.DMP table_exists_action=replace
处理对象类型 SCHEMA_EXPORT/USER
ORA-39083: 对象类型 USER 创建失败, 出现错误:
ORA-00959: 表空间 'EAS_D_NEWDB850BC_STANDARD' 不存在
失败的 sql 为:
CREATE USER "NEWDB850BC" IDENTIFIED BY VALUES 'S:B5845A020A525DF05D3ACF2FD09