Wednesday, April 20, 2016

How to create your own schema in Oracle 11G


login using sys
i.e. / as sysdba

CREATE BIGFILE TABLESPACE tbs_perm_android_01
DATAFILE 'tbs_perm_android_01.dat'
SIZE 10M
AUTOEXTEND ON;

CREATE TEMPORARY TABLESPACE tbs_temp_android_01
TEMPFILE 'tbs_temp_android_01.dbf'
SIZE 5M
AUTOEXTEND ON;


CREATE USER android
IDENTIFIED BY android
DEFAULT TABLESPACE tbs_perm_android_01
TEMPORARY TABLESPACE tbs_temp_android_01
QUOTA 20M on tbs_perm_android_01;

GRANT create session TO android;
GRANT create table TO android;
GRANT create view TO android;
GRANT create any trigger TO android;
GRANT create any procedure TO android;
GRANT create sequence TO android;
GRANT create synonym TO android;

No comments: