plsql创建数据库表、表空间

--创建表空间
create tablespace glpt
datafile 'E:\oracle\product\10.2.0\oradata\orcl\glpt.dbf' size 500M
autoextend on next 100M maxsize unlimited logging
extent management local autoallocate
segment space management auto;

--创建临时表空间
create temporary tablespace glpt_temp
tempfile 'E:\oracle\product\10.2.0\oradata\orcl\glpt_temp.dbf'
size 320m
autoextend on
next 32m maxsize 2048m
extent management local;

--创建用户
create user glpt identified by wellhope
default tablespace glpt
temporary tablespace glpt_temp;

--用户授权
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO glpt;