创建临时表空间
- create temporary tablespace test_temp
- tempfile 'E:\Oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'
- size 32m
- autoextend on
- next 32m maxsize 2048m
- extent management local;
创建数据表空间
- create tablespace test_data
- logging
- datafile 'E:\Oracle\product\10.2.0\oradata\testserver\test_data01.dbf'
- size 32m
- autoextend on
- next 32m maxsize 2048m
- extent management local;
Oracle创建用户并指定表空间
- create user username identified by password
- default tablespace test_data
- temporary tablespace test_temp;
给用户授予权限
- grant connect,resource to username;
- 收回权限:
- revoke from username;