oracle数据库的创建

--创建数据表空间
create tablespace mytablespace
datafile 'd:/mytablespace.dbf'
Size 32m
autoextend on
maxsize unlimited;

--创建临时表空间
create temporary tablespace temptablespace
tempfile 'd:/mytempspace.ldf'
size 32m
autoextend on
maxsize unlimited;

--删除数据表空间和临时表空间
drop tablespace mytablespace including contents and datafiles;
drop tablespace temptablespace including contents and datafiles;

--为表空间创建用户
create user my identified by hht default tablespace mytablespace temporary
tablespace temptablespace;

--授权和收回
grant connect,resource to my;
revoke connect,resource from my;

--修改用户密码
alter user my identified by www;

--删除用户和所有模式
drop user my cascade;