CREATE TABLE TABLE_NAME_TEMP AS

   SELECT *

     FROM TABLE_NAME AS OF TIMESTAMP( SYSTIMESTAMP - INTERVAL '30' MINUTE );

TABLE_NAME TABLE의 30분이전 데이타를 TABLE_NAME_TEMP란 테이블로 생성하는 쿼리~