sqlplus / as sysdbaCREATE TABLESPACE test
DATAFILE 'D:\oracle\oradata\test\test.dbf'
SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
CREATE USER username IDENTIFIED BY password
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
GRANT CONNECT, RESOURCE, DBA TO username;
COMMIT;AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED:自動擴展,避免空間不足EXTENT MANAGEMENT LOCAL:本地管理區塊,效能優於字典管理TEMPORARY TABLESPACE:指定暫存表空間,避免排序/雜湊操作佔用系統表空間