创建表

--创建临时表空间
create temporary tablespace wzBlog_temp
tempfile 'D:\DB\wzBlog_temp.dbf'
size 100m
autoextend on
next 50m maxsize 2048m
extent management local;

--创建数据表空间
create  tablespace  wzBlog
datafile 'D:\DB\wzBlog.dbf'
size 1024m
autoextend on
next 50m maxsize 2048m
extent management local;

--创建用户并指定表空间
create user wzBlog identified by wzBlog
default tablespace wzBlog
temporary tablespace wzBlog_temp;

--给用户授予权限

grant dba to wzBlog;

导入

imp student/student@192.168.1.121:1521/student_test file=D:\test20150930.dmp   full=y

导出
exp student/student@192.168.1.121:1521/student file=D:\20150929.dmp owner=student