oracle 导入 导出 示例 （创建表空间、用户、授权）

oatest oatest  
chubeiliang2    W1Q2W3E4R5T88CHUBEILIANG
safety  safety2017a 
emergency  emergency2017ae


--安全
create tablespace CBL_SAFETY_DATA 
logging
datafile '+DATA/zjscbldb/datafile/CBL_SAFETY_DATA.dbf'
size 300m
autoextend on
next 300m maxsize unlimited
extent management local;


create user SAFETY identified by safety2017a
  default tablespace CBL_SAFETY_DATA
  temporary tablespace TEMP
  profile DEFAULT
  quota unlimited on cbl_safety_data;
-- Grant/Revoke role privileges 
grant connect to SAFETY;
grant resource to SAFETY;
-- Grant/Revoke system privileges 
grant unlimited tablespace to SAFETY;