Check out example codes for "oracle db create new schema". It will help you in understanding the concepts better.

Code Example 1

CREATE USER smith IDENTIFIED BY password;

Code Example 2

-- 1st Step
CREATE USER user_name IDENTIFIED BY password;
-- 2nd step
GRANT RESOURCE TO user_name;
GRANT CONNECT TO user_name;
GRANT CREATE VIEW TO user_name;
GRANT CREATE SESSION TO user_name;
GRANT UNLIMITED TABLESPACE TO user_name;

Code Example 3

GRANT CREATE TABLE TO smith;

Learn ReactJs, React Native from akashmittal.com