Listing Files to Import

This action (filesToImport) is used to list the files needed to import the data between the given dates into the following supported tables:

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

If these files have been moved to another location since the original archiving operation (e.g., moved to tape), they must be restored to a directory accessible from the database server with their original file names.

This command uses the following flags:

-action

filesToImport

-tableName

<table name>

-startDate

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

-endDate

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

-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 filesToImport:

Execute this command as follows:

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

The following example lists all files containing data between dates "09/25/2007 00:00:00" (Sep 25th midnight) and "09/26/2007 00:00:00" (Sep 26th midnight) that have been previously archived.

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

sdm –action filesToImport -tableName Events –startDate 09/25/200\7 00:00:00 –endDate 09/26/2007 00:00:00 –connectFile sdm.connect

The following example lists all the files containing the data between dates "09/25/2007 16:00:00" (Sep 25th 4 PM) and "09/26/2007 18:00:00" (SEP 26, 6 PM) that has been archived earlier and can be imported back.

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

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