--删除表空间
DROP TABLESPACE TS_BGPDDC INCLUDING CONTENTS AND DATAFILES;
--创建数据表空间
create tablespace TS_BGPDDC
logging
datafile 'K:\oracle\product\10.2.0\oradata\orcl\TS_BGPDDC.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
--删除用户
DROP USER BGPDDC cascade;
--创建用户并指定表空间
create user BGPDDC identified by bgpddc default tablespace TS_BGPDDC Temporary tablespace TEMP;
grant connect,resource,dba to BGPDDC;
revoke unlimited tablespace from BGPDDC;
alter user BGPDDC quota 0 on Users;
alter user BGPDDC quota unlimited on TS_BGPDDC
改变表空间大小
alter database datafile 'C:\SDE.DBF' resize 5G;