Monday, March 29, 2021

Removing the existing APEX


Removing the existing APEX 

 

SQL> @apxremov.sql

 

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

...Removing Application Express

...set_appun.sql

Session altered.

PL/SQL procedure successfully completed.

...set_ufrom_and_upgrade.sql

PL/SQL procedure successfully completed.

Session altered.

PL/SQL procedure successfully completed.

...set_appun.sql

Session altered.

PL/SQL procedure successfully completed.

...set_ufrom_and_upgrade.sql

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

...set_appun.sql

Session altered.

PL/SQL procedure successfully completed.

...set_ufrom_and_upgrade.sql

PL/SQL procedure successfully completed.

User dropped.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Package dropped.

PL/SQL procedure successfully completed.

...Application Express Removed

 

********************************************************************

** You must exit this SQL*Plus session before running apexins.sql **

********************************************************************


set the apex lisneter port to 0

No comments:

Table import and export.

Create Data Pump Directory. The first step in Oracle Data Pump is to create an OS level directory which will be used by Oracle for perform...