Go to cmd:
-- Enter with sys account
Sqlplus sys/admin as sysdba;
-- Create a tablespace
Create temporary tablespace sms_temp
Tempfile 'e: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ sms_temp.dbf' size 20 m
Autoextend on;
Create tablespace sms_data
Datafile 'e: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ sms_data.dbf' size 20 m
Autoextend on;
--- Create a user
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;