创建表空间：创建用户：
CREATE SMALLFILE TABLESPACE "GWBZB200W" DATAFILE 'E:oracleproduct10.2.0oradatazbgwdbgwbzb200w ' SIZE 1000M AUTOEXTEND ON NEXT 102400K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE USER "W200" PROFILE "DEFAULT" IDENTIFIED BY "111111" DEFAULT TABLESPACE "GWBZB200W" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "W200";
GRANT "DBA" TO "W200";

GWBZB200W为创建的表空间名称，E:oracleproduct10.2.0oradatazbgwdbgwbzb200w为orcal的安装目录，

W200 111111分别为用户名和密码，GRANT "DBA" TO "W200";赋予用户dba的权限