- //創建臨時表空間
-
- create temporary tablespace user_temp
- tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf'
- size 50m
- autoextend on
- next 50m maxsize 20480m
- extent management local;
-
- //創建數據表空間
- create tablespace test_data
- logging
- datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf'
- size 50m
- autoextend on
- next 50m maxsize 20480m
- extent management local;
-
- //創建用戶并指定表空間
- create user username identified by password
- default tablespace user_data
- temporary tablespace user_temp;
-
- //給用戶授予權限
-
- grant connect,resource to username;
-
- //以后以該用戶登錄，創建的任何數據庫對象都屬于user_temp 和user_data表空間，這就不用在每創建一個對象給其指定表空間了
- 該文章轉載于：http://lpcjrflsa.javaeye.com/blog/309811
|