- 1、创建临时表空间
- 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;
- 说明:红色字体是注意修改的地方。
来源: