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