//创建表空间
CREATE TABLESPACE kmhbdc_data
LOGGING
DATAFILE 'F:\oracle\product\10.2.0\oradata\orcl\KMHBDC_DATA.DBF '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL;
//创建临时表空间
CREATE TEMPORARY TABLESPACE kmhbdc_temp
TEMPFILE 'F:\oracle\product\10.2.0\oradata\orcl\KMHBDC_TEMP.DBF '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL;
//删除表空间
DROP TABLESPACE KMHBDC_TEMP INCLUDING CONTENTS AND DATAFILES;
在利用PL/SQL创建用户的时候给用权限 有角色权限 dba resouce