oracle 创建表空间

1. 统管理员登陆oracle：system/123456

2. 表空间建立

CREATE TABLESPACE KDM

LOGGING

DATAFILE'D:\Program\oracleTablespace\KDM_DATA_BAK.DBF'

SIZE 32M

AUTOEXTEND ON

NEXT 32M MAXSIZE 2048M

EXTENT MANAGEMENT LOCAL;

 

3. 创建用户

CREATE USER KDM IDENTIFIED BY KDM

DEFAULT TABLESPACE KDM;

 

4. 授权

GRANT  CREATESESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANYPROCEDURE, ALTER ANY TABLE, ALTER ANY PROCEDURE, DROP ANY TABLE, DROP ANY VIEW,DROP ANY INDEX, DROP ANY PROCEDURE, SELECT ANY TABLE, INSERT ANY TABLE, UPDATEANY TABLE, DELETE ANY TABLE TO KDM;