Talk

define tablespaceName = TBS_USER
define userName = USER
define userPW = PASSWORD

CREATE TABLESPACE &tablespaceName
DATAFILE '&tablespaceName..ora'
SIZE 1M REUSE AUTOEXTEND ON
NEXT 1M MAXSIZE 2040M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 100K;

CREATE USER &userName. IDENTIFIED BY &userPW.
DEFAULT TABLESPACE &TablespaceName.
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON &tablesapceName;

GRANT connect,resource,create session,select any table,create table,create procedure,create trigger,create view,create sequence,create synonym,create public synonym TO &userName;