My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.