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 ,显示的表空间以及表空间的文件如下:

posted @ 2013-09-11 01:34  jasen.kin  阅读(...)  评论(...编辑  收藏