oracle 创建表空间，用户
以system /SYSDBA用户登录创建

1.创建表空间
create tablespace ITSM_WJ
datafile 'D:\oracle\product\10.2.0\oradata\orcl\ITSM_WJ' size 3000M
AutoExtend On Next 100M Maxsize 30720M extent management local uniform size 128k segment space management auto;

2.创建用户
create user itsm_wj identified by itsm default tablespace itsm_wj temporary tablespace temp;
注：登录时：Username:itsm_wj Password:itsm
3.给用户赋予权限
grant dba,connect, create session, resource to itsm_wj;
4.--表空间大小不够时，imp数据不成功 处理方法
revoke unlimited tablespace from ITSM_WJ;
alter user ITSM_WJ quota 0 on ITSM;
alter user ITSM_WJ quota unlimited on ITSM_WJ;

imp ITSM_WJ/itsm@ORCL TABLESPACES=ITSM_WJ FILE=D:\bak\itsm_wj82_427.dmp ignore=Y full=Y BUFFER=102400


5.导出
exp itsm/itsm@ITSM file=d:\itsm.dmp owner=itsm

6.导入
imp itsm/itsm@ITSM file=d:\itsm0814.dmp ignore=y full=y

imp itsm_wj/itsm@192.168.168.199 file=d:\0331.dmp ignore=y full=y

7.查看表空间下面有哪些表
select table_name from all_tables where tablespace_name= 'ITSM_WJ';