Oracle uses the command line to create a new account

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;