hi all,
i am loading data by running a .ctl file. everytime the ctl file is run, it first truncates all the records and loads the fresh data from a csv file. now what i want is, it should count the number of records that are previously there in the table and store the count(*) in different table and then proceed for the truncation. how can it be done?