Apex setup procedure

   1.  oracle developer  installation

       a. tablespaces create (gracework)
         create tablespace Gracework datafile 'C:oraclexeapporacleoradataXEGRACEWORK.DBF' SIZE 20M AUTOEXTEND ON;

       b. User table create (gracework)


   2.  EditPlus 3.40

   3.  apex express (XE) installation
       workspace create (gracework thru XE admin)

   4.  import dmp file
  
       copy image table to wwv_flow_files
       insert into wwv_flow_files   select * from  FLOW_FILES_IMAGE_T  

   5.  import gracework application

   6.  setup email (SMTP) procedures

       a) port change 2525 (Windows-> System32 --> Drivers --->etc -->Service

       b) port change APEX Admin  ---> Manage Instancde ->Instance Settings ->

       c) run smtp proc thru command line (email folder) 
      
       d) recompile procedure GRACE_KOEMAIL, PROCSEND_BATCH_EMAIL (after change port number and korean character)

       e) port change for network
  
   7.  Increase speed
    
       from sqlplus

       alter system set sessions=250 scope=spfile;
       alter system set processes=200 scope=spfile;
  
   8. Increase excess user

       run regeidt

    a)   HKEY_LOCAL_MACHINESOFTWAREMicrosoftInternet Explore
       MAINFeatureControlFEATURE_MAXCONNECTIONSPERSERVER

       and

       HKEY_LOCAL_MACHINESOFTWAREMicrosoftInternet Explore
       MAINFeatureControlFEATURE_MAXCONNECTIONSPER1_0SERVER 
    b)
       Now create DWORD Value called iexplore.exe for both sub keys
       to 10 or as desired