Create the following details to create :
username : archive_purge
password: archive123
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;