I have a set of history tables and main tables. I move records from the main table to the history table at regular intervals and export from the history tables.
How do I restore the records back into the main table and not history table?
Thank You
Printable View
I have a set of history tables and main tables. I move records from the main table to the history table at regular intervals and export from the history tables.
How do I restore the records back into the main table and not history table?
Thank You
(Assuming you have a table called HISTORY and a table called MAIN). You can't. You will have to import back into the HISTORY table and then insert to the MAIN table.