1、进入命令行

? ?sqlplus / as sysdba 回车

2、create tablespace bca

logging ?

datafile 'D:\oracle10\product\10.2.0\oradata\orcl\bca.dbf'?

size 1024m ?

autoextend on ?

next 50m maxsize 20480m ?

extent management local;?

?

3、create user bjyd identified by bjyd?

default tablespace bca ；

?

create user bcacc identified by shark

default tablespace bca ；

create user bca identified by shark

default tablespace bca ；

create user bcalog identified by shark

default tablespace bca ；

?

grant dba,resource,connect to bjyd;

grant select any table to bjyd;

grant update any table to bjyd;

grant delete any table to bjyd;

grant insert any table to bjyd;

?

grant resource,connect to bca;

?

grant resource,connect to bcacc;

?

grant resource,connect to bcalog;

?

?

imp bjyd/bjyd 'dump文件目录' fromuser='数据来源用户' touser='导入用户'

?

imp bjyd/bjyd ?'dump文件目录' full=y ?// 默认导入到bjyd用户下