//创建表空间
create tablespace admin_data
logging
datafile 'd:\oracle\oradata\admin_data.dbf'
size 100m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建临时表空间
create temporary tablespace admin_temp
tempfile 'd:\oracle\oradata\admin_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建用户
create user 用户名 identified by 密码
default tablespace 表空间名
temporary tablespace 临时表空间名
create user admin identified by admin
default tablespace admin_data
temporary tablespace admin_temp;
//授权
grant dba to admin;
//导入
imp userid=admin/admin@xe file=d:\test.dmp full=y