CREATE TABLESPACE TIMECARD
LOGGING
DATAFILE 'D:\ORACLE\ORADATA\MYDB\MYTEMP1.ora' SIZE 50M REUSE
AUTOEXTEND
ON NEXT 640K MAXSIZE 32767M DEFAULT
STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 0
PCTINCREASE 0 ) TEMPORARY
LOGGING
DATAFILE 'D:\ORACLE\ORADATA\MYDB\MYTEMP1.ora' SIZE 50M REUSE
AUTOEXTEND
ON NEXT 640K MAXSIZE 32767M DEFAULT
STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 0
PCTINCREASE 0 ) TEMPORARY
'C:\Orant\DataBase\LibraCrm.dbf' Size 300M Reuse
AUtoExtend On Next 2M Maxsize 500M Minimum Extent 128k
DEFAULT Storage(initial 25k next 15k MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0);Commit;-- 临时表空间的创建Create TableSpace Temp_LibraCrm DataFile
'C:\Orant\DataBase\Temp_LibraCrm.dbf' Size 100M Reuse Temporary;Commit;-- 创建用户 Create User LibraUser Identified by LibraUser1976
Default TableSpace LibraCrm Temporary TableSpace Temp_LibraCrm
Quota 0 On System;Commit;-- 用户授权Grant DBA To LibraUser;commit;
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/tspaces.htm#544
DATAFILE Datafile_Options Storage_Options ;Datafile_Options: 'filespec' [AUTOEXTEND OFF]
'filespec' [AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]]
The Autoextend Maxsize clause will default to UNLIMITED if no value is specified. Storage_Options: DEFAULT STORAGE storage_clause
MINIMUM EXTENT int {K|M}
LOGGING | NOLOGGING
ONLINE | OFFLINE
PERMANENT | TEMPORARY
EXTENT MANAGEMENT {DICTIONARY |
LOCAL {AUTOALLOCATE | UNIFORM [SIZE int K | M]} }
http://otn.oracle.com/pls/tahiti/tahiti.tabbed?section=75124