ORACLE10g创建表空间，角色与授权

创建基础表空间，创建用户，授权。

 -- CREATE TABLESPACE
  CREATE TABLESPACE TS_JK_LAB_BASIC 
  DATAFILE 'D:\TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\JK_LAB\TS_JK_LAB_BASIC01.DBF' SIZE 3000M ,
           'D:\TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\JK_LAB\TS_JK_LAB_BASIC02.DBF' SIZE 3000M ,
           'D:\TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\JK_LAB\TS_JK_LAB_BASIC03.DBF' SIZE 3000M 
  AUTOEXTEND ON
  NEXT 1000M 
  MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL 
  UNIFORM SEGMENT SPACE MANAGEMENT AUTO; 

  
 -- DROP TABLESPACE COMMAND
 ---- DROP TABLESPACE TS_JK_LAB_BASIC;

  
 -- SELECT ALL TABLESPACE AND DBF FILES
  SELECT * FROM DBA_DATA_FILES ;

 
 -- CREATE USER AND GIVE THE DEFAULT TABLESPACE
  CREATE USER jasenkin IDENTIFIED BY jasenkin DEFAULT TABLESPACE TS_JK_LAB_BASIC;

  
 -- GRANT THE ROLE TO USER
  GRANT RESOURCE,CONNECT,DBA TO jasenkin;

 

执行命令 SELECT * FROM DBA_DATA_FILES ，显示的表空间以及表空间的文件如下：