创建表空间:
create tablespace username datafile 'C:\Oracle\product\10.2.0\oradata\orcl\username.dbf' size 50m autoextend on next 50m;
创建用户:
CREATE USER USER_NAME
IDENTIFIED BY "USERPASSWORD"
DEFAULT TABLESPACE USER_TABLESPACE
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
GRANT CONNECT TO USER_NAME;
GRANT RESOURCE TO USER_NAME;
GRANT DBA TO USER_NAME;