(单纯记录,方便日后查看)
oracle数据库创建表空间与用户
#创建表空间
CREATE TABLESPACE %tablename% LOGGING DATAFILE ‘路径/%tablename%.DBF’ SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
#创建用户
create user %username% IDENTIFIED BY %password% default tablespace %tablename% profile DEFAULT;
#授予用户权限
grant connect,resource,dba to %username%;
#删除表空间及物理文件
drop tablespace %tablename% including contents and datafiles cascade constraint;