이전 데이터 조회 오류 (오라클)

Question

SELECT count(*) FROM BOARD AS OF TIMESTAMP(SYSTIMESTAMP-INTERVAL '5' DAY); SELECT count(*) FROM BOARD AS OF TIMESTAMP(SYSTIMESTAMP-INTERVAL '4' DAY); SELECT count(*) FROM BOARD AS OF TIMESTAMP(SYSTIMESTAMP-INTERVAL '3' DAY); SELECT count(*) FROM BOARD AS OF TIMESTAMP(SYSTIMESTAMP-INTERVAL '2' DAY); SELECT count(*) FROM BOARD AS OF TIMESTAMP(SYSTIMESTAMP-INTERVAL '1' DAY); SELECT count(*) FROM BOARD AS OF TIMESTAMP((SYSDATE-5)); SELECT count(*) FROM BOARD AS OF TIMESTAMP((SYSDATE-4)); SELECT count(*) FROM BOARD AS OF TIMESTAMP((SYSDATE-3)); SELECT count(*) FROM BOARD AS OF TIMESTAMP((SYSDATE-2)); SELECT count(*) FROM BOARD AS OF TIMESTAMP((SYSDATE-1));5일~1일전 데이터 총량을 쓸곳이 있어서 이렇게 작성 했는데 ORA-01466, ORA-01555 오류가 나더라구요...이걸 어떻게 고쳐야 하나요???

쿠잉 · Answer

불가능 합니다.

drunkenprogram · Answer

그럼 이전 데이터 조회는 불가능 한가요???

이전 데이터 조회 오류 (오라클)

2개의 답변

Q&A 목록