Administration Functions and Tools › Archiving and Purging Historical Data › Archive the Data › Archive the Data in Oracle

Archive the Data in Oracle

This section describes archiving the data in Oracle.

Note: We recommend that you use Oracle SQL Developer to execute the stored procedure.

Follow these steps:

1. Log in to MDB as usm_user or sa using Oracle SQL Developer
2. Navigate to Connections, connection name , Procedures
   • USM_SP_ARCHIVE_DATA
   • USM_SP_PURGE_DATA
3. Right-click on one of the procedures and select Run
4. In Run PL/SQL window replace <…> tags with required information

   Note: If you are using SQLPlus on command prompt, execute the SET SERVEROUT ON statement before executing the stored procedure.

   DECLARE
     P_OBJECT_TYPE VARCHAR2(200);
     P_DATE DATE;
     P_BU VARCHAR2(200);
   BEGIN
     P_OBJECT_TYPE := ‘<Object Type>’;
     P_DATE := ‘<Completion Date on or before - DD-MON-YYYY>’;
     P_BU := ‘<Business Unit>’;
   
     USM_SP_ARCHIVE_DATA(
       P_OBJECT_TYPE => P_OBJECT_TYPE,
       P_DATE => P_DATE,
       P_BU => P_BU
     );
   END;
   

5. After replacing the values above click on OK button.

   The result is displayed in the Running - Log tab.

   On successful completion of the stored procedure, the data is archived.