text: --Source: HR_DEV2@TEAMWORKRM:1521/ORCL (latest repository revisions)
  --Target: HR_RM@TEAMWORKRM:1521/ORCL 
  
  --Script generated by \ on 24/08/2017 19:42
  --Note: Please review this script prior to execution
  
  HOST mkdir "C:\automation\hr\Spool"
  SPOOL C:\automation\hr\Spool\2017-08-24-074236_Output_Spool.log APPEND
  
  SET SERVEROUTPUT ON
  SET DEFINE OFF
  SET BLOCKTERMINATOR OFF
  SET SQLBLANKLINES ON
  
  PROMPT Fetching invalid objects before deployment actions
  PROMPT ****************************************************************************
  SELECT OBJECT_NAME, OBJECT_TYPE, STATUS
  FROM   ALL_OBJECTS
  WHERE  STATUS <> 'VALID' AND OWNER = USER;
  
  -- Step 1: Dropping columns
  EXECUTE DBMS_OUTPUT.PUT_LINE('Step 1: Dropping columns');
  -- Warning 1: Dropping columns
  ALTER TABLE "EMPLOYEES" DROP COLUMN "HAS_DENTAL" CASCADE CONSTRAINTS;
  
  -- Step 2: Creating indexes 
  EXECUTE DBMS_OUTPUT.PUT_LINE('Step 2: Creating indexes ');
  
    CREATE INDEX "IDX_PHONES" ON "EMPLOYEES" ("PHONE_NUMBER") 
    ;
  
  -- Step 3: Recompiling invalid objects
  EXECUTE DBMS_OUTPUT.PUT_LINE('Step 3: Recompiling invalid objects');
  BEGIN
  DBMS_UTILITY.COMPILE_SCHEMA(USER, FALSE, FALSE);
  END;
  /
  
  
  PROMPT Fetching invalid objects after deployment actions
  PROMPT ****************************************************************************
  SELECT OBJECT_NAME, OBJECT_TYPE, STATUS
  FROM   ALL_OBJECTS
  WHERE  STATUS <> 'VALID' AND OWNER = USER;
  
  
  SET SQLBLANKLINES OFF
  SET BLOCKTERMINATOR ON
  SET DEFINE ON
  SPOOL OFF
  
  
  
  
  exit;
  
  