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

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