USAGE:
(In command mode)
arcmain < arc_archive_customer.sql > arc_archive_customer.log
arcmain < arc_restore_customer.sql > arc_restore_customer.log
Backup table:
--- arc_archive_customer.sql -->>
LOGON 127.0.0.1/dbc,dbc;
ARCHIVE DATA TABLE (financial.customer)
, ABORT, RELEASE LOCK, FILE = customer;
LOGOFF;
--- arch_customer.sql --<<
Restore table:
--- arc_restore_customer.sql -->>
LOGON 127.0.0.1/dbc,dbc;
RESTORE DATA TABLE (financial.customer) -- You may use "COPY" instead of "RESTORE" to copy to a table
, RELEASE LOCK, ABORT, FILE = customer;
LOGOFF;
--- arc_restore_customer.sql --<<