Use Teradata arcmain to archive/restore a table

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 --<<

展开阅读全文

没有更多推荐了,返回首页