ORACLE 创建用户，表空间，导入导出实践

drop user autek cascade;

DROP TABLESPACE sis_temp INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE sis_data INCLUDING CONTENTS AND DATAFILES;

create temporary tablespace sis_temp
tempfile '/home/oracle/app/oracle/oradata/orcl/sis_temp.dbf' size 256m reuse
autoextend on next 128m maxsize unlimited
flashback off;

create tablespace sis_data
datafile '/home/oracle/app/oracle/oradata/orcl/sis_data.dbf' size 256m reuse
autoextend on next 128m maxsize unlimited
logging
default nocompress
online
permanent
extent management local autoallocate
flashback off;

create user AUTEK identified by FLYVIDEO  
default tablespace sis_data  
temporary tablespace sis_temp;

grant connect,resource,dba to autek;

exp AUTEK/FLYVIDEO@10.1.212.56/orcl file=E:/kevin/沧州文档/oracle_db/bocz20151129.dmp


imp AUTEK/FLYVIDEO@127.0.0.1/orcl file=E:/kevin/沧州文档/oracle_db/bocz20151129.dmp full=y ignore=y;