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 …
How to Create Custom Schema in Oracle 11g /12c ? Read More »