FLASH BACK QUERY

SELECT COUNT(*) FROM SCHEMA.TABELLA AS OF TIMESTAMP TO_TIMESTAMP('2018-05-8 08:00:00', 'YYYY-MM-DD HH24:MI:SS');

SELECT COUNT(*) FROM SCHAMA.TABELLA;

CREATE TABLE SCHEMA.TABELLA_COPIA AS SELECT * FROM BAAN.TABELLA WHERE 1=2;

INSERT INTO SCHEMA.TABELLA_COPIA SELECT * FROM SCHEMA.TABELLA AS OF TIMESTAMP TO_TIMESTAMP('2018-05-8 08:00:00', 'YYYY-MM-DD HH24:MI:SS');

GRANT SELECT ON SCHEMA.TABELLA TO USER;