create table tableName_bak as select * from tableName as of TIMESTAMP to_timestamp('20120506 101415','yyyymmdd hh24miss');