Oracle表空间和用户操作实例

drop tablespace still including contents and datafiles;
drop tablespace still_temp including contents and datafiles cascade constraints;

drop user still cascade;

create temporary tablespace still_temp tempfile 'D:\oracle\oradata\still\still_temp.dbf'size 50m autoextend on next 50m maxsize 20480m;

create tablespace stillloggingdatafile 'D:\oracle\oradata\still\still.dbf'size 50m autoextend on next 50m maxsize 20480mextent management local;

create user still identified by stilldefault tablespace stilltemporary tablespace still_temp;

grant connect,resource,dba to still;