1.新增一个表
例:CREATE TABLE MESENHANCE.OM_ORDER_TRACK_LOG_COPY AS SELECT * FROM MESENHANCE.OM_ORDER_TRACK_LOG
2.表已经存在
例:INSERT INTO OM_ORDER_TRACK_LOG_COPY SELECT * FROM OM_ORDER_TRACK_LOG WHERE upd_time < SYSDATE - 2;
1.新增一个表
例:CREATE TABLE MESENHANCE.OM_ORDER_TRACK_LOG_COPY AS SELECT * FROM MESENHANCE.OM_ORDER_TRACK_LOG
2.表已经存在
例:INSERT INTO OM_ORDER_TRACK_LOG_COPY SELECT * FROM OM_ORDER_TRACK_LOG WHERE upd_time < SYSDATE - 2;