oracle 创建表空间

 --创建临时表空间:
create temporary tablespace RADIALSOFT_UTIL1
tempfile ‘C:/myoracledb/RADIALSOFT_UTIL01.dbf‘  size 500m autoextend on next 200m maxsize unlimited
extent management local
/

--创建表空间:
 create tablespace RADIALSOFT_UTIL
datafile ‘C:/myoracledb/wlc01.dbf‘  size 500m autoextend on next 200m maxsize unlimited,
‘C:/myoracledb/wlc02.dbf‘  size 500m autoextend on next 200m maxsize unlimited,
‘C:/myoracledb/wlc03.dbf‘  size 500m autoextend on next 200m maxsize unlimited,
‘C:/myoracledb/wlc04.dbf‘  size 500m autoextend on next 200m maxsize unlimited,
‘C:/myoracledb/wlc05.dbf‘  size 500m autoextend on next 200m maxsize unlimited
extent management local
/


注意创建上面两个表空间时的路劲( 如F:/myoracledb)，那个/必须有。

创建用户 并指定默认表空间1
Create user wlc identified by radial_wlc123 default tablespace RADIALSOFT_UTIL temporary tablespace RADIALSOFT_UTIL1;

--创建用户 并指定默认表空间2
create user drv_admin identified by 123 default tablespace myOracle temporary tablespace drv_temp1;
--将dba的权限给用户
grant dba to wlc


3.使用imp命令导入dmp文件
导入备份
imp   wlc/radial_wlc123   file=D:\打包带走\EXPDAT.dmp  full=y    这句实在cmd里面执行的

 备份数据库
exp wlc/radial_wlc123 full=y file=d:\grx.dmp;

oracle 创建表空间

原文：http://www.cnblogs.com/bin521/p/6386984.html