oracle创建对象导入dmp

//创建表空间

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