Rem drv: <migrate type="schema_upgrade" version="10.2.0.4.0"/>
Rem
Rem $Header: audit_schema_upgrade.sql 10-aug-2007.11:09:46 pshishir Exp $
Rem
Rem audit_schema_upgrade.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      audit_schema_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    pshishir    07/27/07 - 
Rem    sbhagwat    06/17/07 - Adding new custom audit attributes to
Rem                           mgmt_user_session
Rem    sbhagwat    06/17/07 - Created
Rem

SET ECHO ON

@&EM_SQL_ROOT/core/10.2.0.4/audit/audit_types.sql
@&EM_SQL_ROOT/core/10.2.0.4/audit/audit_tables.sql

alter session set current_schema=sys;
DECLARE
  l_count number(16);
BEGIN
    BEGIN
       select count(*) INTO l_count from all_directories where DIRECTORY_NAME = 'AUDIT_DIR';
    EXCEPTION
      WHEN NO_DATA_FOUND THEN
        l_count := 0;
    END;
    IF l_count > 0 THEN
        EXECUTE IMMEDIATE 'DROP DIRECTORY AUDIT_DIR';
        COMMIT;
    END IF;
END;
/
alter session set current_schema=&&EM_REPOS_USER;