COMPRESSED_FILE=$DATADIR/perprod_hd_problem.dmp.Z PARFILE=$DATADIR/export_problem.par query="where add_months(close_time, 15) < sysdate" DIRECT=
FILE="s:misscriptsexport_sql.dmp" LOG="s:misscriptsexp_export_sql.log" TABLES=('R11.WO_3068_DEF_EST') QUERY="where csi_id = 115"In one schema the record count was 45,381, and in my other schema where I imported the data my record count was 10,276.
Since my parfile looks very similar to yours, the problem does not appear to be with your parfile.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.