How to Create Custom Schema in Oracle 11g /12c ?

Create  the following  details to create :
 
username : archive_purge

password: archive123

tablespace name : archive_purge

temporary tablespace name: temp

To Create  tablespace :

SQL>CREATE TABLESPACE archive_purge DATAFILE

‘/u01/MIC1213/db/apps_st/data/archive_purge01.dbf’ size 5G;

To Create Create User :

SQL> create user archive_purge identified by archive123 temporary tablespace temp default tablespace archive_purge;

To Permission to User :

SQL> grant connect to archive_purge;

SQL> grant resource to archive_purge;

SQL> grant dba to archive_purge;

SQL> grant unlimited tablespace to archive_purge;

SQL > grant select any table to archive_purge;

 
 

 

Leave a Comment

Your email address will not be published. Required fields are marked *