Database Tables Archiving and Purging Scripts for SQL Server 2005

(Doc ID 1270260.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Adaptive Access Manager - Version 10.1.4.3 and later
Information in this document applies to any platform.

Goal

This Article contains information on the purge and archive scripts on the Oracle Adaptive
Access Manager Database Tables in Microsoft SQL Server 2005. The procedure to trigger the
scripts and information on the verification and validation of script results are also provided.


cr_purge_tables_sqlserver.sql, cr_sp_arch_purge_tracker_data.sql, are the scripts to create
Archive Tables and Stored Procedures. These scripts are to be applied on the Oracle
Adaptive Access Manager Database as one time operation to create archive tables and stored
procedures for scheduled scripts.


cr_archive_purge_tracker_data.sql , cr_archive_purge_rule_log.sql,
cr_archive_purge_vcrypt_users.sql are the scripts to be scheduled or triggered for archiving
based on database management and business requirement policies.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms