Stored Procedure Accelerator Guide for Oracle

9.8.4
- 9.9.3
- 9.9.2
- 9.9.1
- 9.9
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Creating the Clean Up Procedure

Create the CLEANUP_TEMP_OBJECTS procedure.

Open the following file in Notepad:

<Dynamic Data Masking installation>\Accelerators\StoredProcedureMasking\sql\Oracle\CLEAN_TEMP_OBJECTS_JOB_CREATION_TEMPLATE.sql

Use SQL Developer to log in to the database as an administrator.

Paste the text of the CLEAN_TEMP_OBJECTS_JOB_CREATION_TEMPLATE.sql file into the SQL Worksheet.

Run the script to create the CLEANUP_TEMP_OBJECTS procedure.

The CLEANUP_TEMP_OBJECTS has the following attributes:

created_before_seconds: Objects that have a creation time that is before the value of the created_before_seconds attribute are considered for deletion. Specify the time in seconds.
tempdb_schema: The name of the temporary schema where the accelerator creates the temporary objects.

For example, you want to delete the temporary objects in the DDMTEMPDB schema that the accelerator created more than 300 seconds ago. You use the following attribute values:

created_before_seconds : 300

tempdb_schema : 'DDMTEMPDB'

Step 6. Create the Clean Up Procedure

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal