a.创建用户、表空间、分配权限
第1步:创建数据表空间
create tablespace TOPSCF_CHS_BS_TSlogging
datafile 'D:\oracle\product\10.2.0\oradata\zhang\TOPSCF_CHS_BS_TS.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
第2步:创建用户并指定表空间
create user TOPSCF_CHS_BS identified by pass1234
default tablespace TOPSCF_CHS_BS_TS
temporary tablespace temp;
第3步:给用户授予权限
grant connect,resource,dba to TOPSCF_CHS_BS;
========================================================
b.数据库的导出导入,进入cmd
导出:exp topscf_chs_bs/pass1234@DEVE15 file=d:\topscfChsBs.dmp owner=topscf_chs_bs
导入:imp topscf_chs_bs/pass1234@ZHANG file=d:\topscfChsBs.dmp full=y