Re: unload and load tables with serial identifier

In article <744l3r$l51$1@nnrp1.dejanews.com>, adaml420@yahoo.com wrote: > Can you unload and load data back to the tables using serial identifier? > Thanks. Yes. Note that you will need to delete all rows from table before loading if you have unique index on serial column. Or you can drop and recreate table. Or you can change all serial column values to 0 in .unl file if you want to keep all rows in table and add copies of rows with new serial values. In that case during load engine will create new serial values for you. First serial value will be 1 if it is new table (drop & create case). First serial value will be max_used_serial_value + 1 (other cases). > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own > -- Vardan Aroustamian -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own