6Get Historical Data for Export

Export older records by requesting time stamp back fill and exporting in manageable time windows.

To get historical data for export—that is, records created before Export Views were enabled in your environment—submit a service request to Oracle Support.

Oracle back fills the create date and time for historical records, which is required for incremental exports using the API. Oracle assigns artificial time stamps so historical records can be exported in manageable segments. These time stamps don’t reflect original creation or update times.

For example, if your data set contains 30 million rows, the assigned time stamps may span about 3.5 days. You can set a date range in your export parameters, such as a 5-minute window, to retrieve a subset of data at a time. If each row is incremented by 10 milliseconds, a 5-minute window returns roughly 30,000 rows.

Adjust the interval as needed to control the number of rows per export and repeat the process until all required historical data is retrieved.