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';
