CREATE TABLESPACE TBTEST DATAFILE 'e:\ora\WWW.ORA' SIZE 15M ONLINE EXTENT MANAGEMENT LOCAL AUTOALLOCATE LOGGING;CREATE USER "SYNCH" IDENTIFIED BY "SYNCH" DEFAULT TABLESPACE TBTEST TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON TBTEST;GRANT CONNECT TO "SYNCH"; GRANT RESOURCE TO "SYNCH";
然后用系统用户登陆
create user username identified by password
grant dba to username
就可以了
先建立数据库,再针对该数据库建立用户和表空间。
DATAFILE
'e:\ora\WWW.ORA' SIZE 15M
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
LOGGING;CREATE USER "SYNCH" IDENTIFIED BY "SYNCH"
DEFAULT TABLESPACE TBTEST
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON TBTEST;GRANT CONNECT TO "SYNCH";
GRANT RESOURCE TO "SYNCH";