进入cmd:
--以sys账户进入
sqlplus sys/admin as sysdba;
--创建表空间
create temporary tablespace SMS_Temp
tempfile 'E:\oracle\product\10.2.0\oradata\orcl\SMS_Temp.dbf' size 20M
autoextend on;
create tablespace SMS_Data
datafile 'E:\oracle\product\10.2.0\oradata\orcl\SMS_Data.dbf' size 20M
autoextend on;
---创建用户
CREATE USER SMS IDENTIFIED BY admin
DEFAULT TABLESPACE SMS_DATA
TEMPORARY TABLESPACE SMS_TEMP;
-- ROLES
GRANT "RESOURCE" TO SMS ;
GRANT "CONNECT" TO SMS ;
GRANT "DBA" TO SMS ;
-- SYSTEM PRIVILEGES
-- QUOTAS
ALTER USER SMS QUOTA UNLIMITED ON SMS_DATA;
-- USER SQL
ALTER USER SMS
DEFAULT TABLESPACE SMS_DATA
TEMPORARY TABLESPACE SMS_TEMP
ACCOUNT UNLOCK ;
-- ROLES
ALTER USER SMS DEFAULT ROLE "RESOURCE","CONNECT","DBA";
-- SYSTEM PRIVILEGES
REVOKE UNLIMITED TABLESPACE FROM SMS;
-- QUOTAS
ALTER USER SMS QUOTA UNLIMITED ON SMS_DATA;