I want to know the installation process of utPLSQL.

Question

I am doing a PLSQL project and for that I want to set up utPLSQL to write a unit test. But error is coming while installation. Please guide me how to do it.

Answer 1

FIrst of all it is necessary to connect to sqlplus as SYSTEM - a power user on your database which will create a UTP user.

SQL> connect system/< the system's password >

SQL> create user utp identified by utp default tablespace

       users temporary tablespace temp;

SQL> grant create session, create table, create procedure,

      create sequence, create view, create public synonym, drop public synonym to utp;

SQL> alter user utp quota unlimited on users;

Then only run

SQL> ut_i_do install 

If you want to get more insights into SQL, checkout this SQL Course from Intellipaat.