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 one of the procedures and select Run.
4. In the Run PL/SQL window, replace the values inside the carets (< >) with required data.

   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 OK.

   The result is displayed in the Running - Log tab.

The data is archived.