Oracle创建、删除表空间、用户

1、Oracle创建临时表空间create temporary tablespace linshi tempfile "e:linshi.dbf" size 50m autoextend on next 50m maxsize 20480m extent management local; 2、创建数据表空间create tablespace fansik logging datafile "e:fansik.dbf" size 50m autoextend on next 50m maxsize 20480m extent management local; 3、创建用户并指定表空间create user fansik identified by fanjinbao default tablespace fansik temporary tablespace linshi; 4、给用户授予权限grant connect,resource,dba to username;
5、删除用户drop user fansik cascade;
6、删除表空间文件
drop tablespace fansik including contents and datafiles;

说明：红色字体是注意修改的地方。更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址