oracel新建用户导入数据库

1、创建表空间

create tablespace data_test datafile 'D:\ProgramFiles\oracle\oradata\test\data_1.dbf' size 200M;

2、创建用户
create user dbname identified by 123456 default tablespace data_test;

3、给用户授权
grant resource,connect,dba to dbname;

4、导入数据库
imp warem/123456@192.168.10.62/orcl file=D:\javashop\warem\db\dbname.dmp full=y;