Schema Creation in Oracle.

create Tablespace:
create tablespace HSS datafile 'C:\oracle\product\10.2.0\oradata\orcl\HSS.dbf'size 200M autoextend ON maxsize 1800M;


To Create User:
create user hypuser identified by password default tablespace HSS temporary tablespace TEMP;


Grant Permissions:
grant CONNECT,RESOURCE, ALTER SESSION,CREATE CLUSTER,CREATE DATABASE LINK,CREATE SEQUENCE,CREATE VIEW,CREATE SYNONYM to hypuser;