To Search and Restore data using a parameter file named SNR.TXT that supplies command-line and override keywords, enter:
PR0CMND /R @C:\TEMP\SNR.TXT
In this example, the parameter file C:\TEMP\SNR.TXT includes the following:
TYPE=SEARCHANDRESTORE REQUEST=RESTR.MODEL1 OV=* FILTER FILENAME C:\ACCTS\%.AF FILTER SERVERNAME SYS_ FILTER GROUP ACCTS FILTER CREATOR % FILTER TABLENAME %.TEST.% GLOCONN OR GLOSELCRIT %.%.CUSTOMERS CUST_ID > '123' GLOCOLCONN %.%.CUSTOMERS OR GLOSQLTEXT %.%.CUSTOMERS CUST_ID< '10' and STATE = 'FL' SORTORDER Ascending MAXFILES 5 ONLYFIRST No DELARES Yes IGNINACC Yes CONONERR Yes CFFILE C:\TEMP\OverSeaInsert.cf TMNAME pstdoc.PST COMMFREQ 200 PROCTYPE UpdIns LOCKTABS No DISROWLIM 0 COLMAPID L_MSS70 COLMAP CUSTOMERS L_MSS70.CUST DESTQUAL PSTDOC.PRODCTN DESTTABNAME CUSTOMERS CUST_RES END
To Search and Restore data using an override file named SNROVRDS.TXT that supplies overrides, enter:
PR0CMND /R TYPE=SEARCHANDRESTORE REQUEST=RESTR.MODEL2 /OV=SNROVRDS.TXT
In this example, the override file, SNROVRDS.TXT, includes the following:
FILTER TABLENAME ORA.%.% FILTER STARTDATE 02/14/2001 FILTER ENDDATE 04/30/2001 SORTORDER Ascending MAXFILES 100 ONLYFIRST No IGNINACC Yes CONONERR Yes CFFILE C:\TEMP\Loadsear.cf TMNAME pstdoc.PST MODE Oracle Append PERFLOAD Oracle Y DELONSUCCESS Y DELONFAILURE N COLMAP CUSTOMERS L_MSS70.CUST DESTQUAL PSTDOC.PRODCTN DESTTABNAME CUSTOMERS CUST_RES END