Deleting Imported Data

The droImported action deletes the imported data between the given dates from the following supported tables:

NOTE:The tables are imported in Oracle with the same name they are archived with.

If there is no data imported between two specified dates, the command returns a notification.

This command uses the following flags:

Table 8 Deleting Imported Data Flags

 

 

-action

dropImported

-startDate

<mm/dd/yyyy hh24:mi:ss>

-endDate

<mm/dd/yyyy hh24:mi:ss>

-tableName

<table name>

-connectFile

<filePath>

NOTE:hh24 is hours represented in 24-hour format. For example, 1:15:00 p.m. is 13:15:00 and 3:00:00 a.m. is 03:00:00.

To run dropImported:

  1. Execute this command as follows:

    -action dropImported -startDate <mm/dd/yyyy hh24:mi:ss> -endDate <mm/dd/yyyy hh24:mi:ss> -tableName <table name> -connectFile <filePath>
    

    The following example deletes the imported data between the given dates from the tables.

    • PostgreSQL Example:

      ./sdm –action dropImported –startDate 09/25/2007 00:00:00 –endDate 09/26/2007 00:00:00 -tableName Events –connectFile sdm.connect
      

For trademark and copyright information, see Legal Notices.