Install and Uninstall Oracle Apex

To install apex your PC have must oracle setup

1.  open CMD with adminstrator

2.  goto the path of apex software using CMD command like
     CD D:/apex

3.  goto sqlplus and login with sys as sysdba

4.  select name from v$datafile

5. CREATE TABLESPACE apex DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\apex.dbf' SIZE 10M  AUTOEXTEND      ON NEXT 1M;
    (Here we create a table space for apex application) 

6. @apexins.sql APEX1 APEX1 TEMP /i/ (***This i must be lower case!!!)

7. @apxchpwd.sql   for password set

8. @apxldimg  F:\apex1  ( load images what u use in apex)

9.  ALTER USER ANONYMOUS ACCOUNT UNLOCK ; (unlock nonymous user)

10. @apxlding.sql D: ( images load confirm) 

11.  EXEC DBMS_XDB.sethttpport(8080) ; (makeing a port for apex you can      take any port number)

 

Remove/ Uninstall Apex:

$ sqlplus /nolog

SQL> connect / as sysdba

Connected.SQL> @apxremov.sql

PL/SQL procedure successfully completed.

…Application Express Removed