Oracle 建立 Table Space & User

開 Table Space
CREATE TABLESPACE "S210"
LOGGING
DATAFILE 'C:\ORACLE\ORADATA\S210DB\S210.ora' SIZE 500M EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

開 User
CREATE USER "S210" PROFILE "DEFAULT"
IDENTIFIED BY "password" DEFAULT TABLESPACE "S210"
ACCOUNT UNLOCK;
GRANT CREATE SESSION TO "S210"
GRANT UNLIMITED TABLESPACE TO "S210"
GRANT "CONNECT" TO "S210";
GRANT "RESOURCE" TO "S210";