Valid For

Extract

Description

Use the ROLLOVER parameter to specify the interval at which trail files are aged and new ones are created. ROLLOVER is global and applies to all trails defined with RMTTRAIL or RMTFILE statements in a parameter file.

Use ROLLOVER to create trail files that represent distinct periods of time (for example, each day). It facilitates continuous processing while providing a means for organizing the output. It also provides a means for organizing batch runs by deactivating one file and starting another for the next run.

Files roll over between transactions, not in the middle of one, ensuring data integrity. Checkpoints are recorded when files roll over to ensure that previous files are no longer required for processing.

Rollover occurs only if the rollover conditions are satisfied during the run. For example, if ROLLOVER ON TUESDAY is specified, and data extraction starts on Tuesday, the rollover does not occur until the next Tuesday (unless more precise ROLLOVER rules are specified). You can specify up to 30 rollover rules.

Rollover is required when the DB_UNIQUE_NAME parameter is changed at the source. The reason is that changing that parameter requires the instance itself to be stopped and restarted. After restarting, Extract starts the new trail file in the sequence according to the existing rollover logic. Other processes such as Data Pump, DS, and Replicat don't abend or require a restart after DB_UNIQUE_NAME parameter is changed.

If the value of the DbUniqueName token on the source changes, then Data Pump and Distribution Server cause a rollover to the next trail file in order to maintain a correct value for the unique name in the trail header.

Either the AT or ON option is required. Both options can be used together, and in any order. Using AT without ON creates a new trail file at the specified time every day.

A trail sequence number can be incremented from 000001 through 999999, and then the sequence numbering starts over at 000000.

Default

Roll over when the default file size is reached or the size specified with the MEGABYTES option of the ADD RMTTRAIL or ADD EXTTRAIL command is reached.

Syntax

ROLLOVER {AT hh:mi | ON day | AT hh:mi ON day} [REPORT]

AT hh:mi

The time of day to age the file.

Valid values:

• hh is based on a 24-hour clock, with valid values of 1 through 23.

• mi accepts values from 00 through 59.

ON day

The day of the week to age the file.

Valid values:

SUNDAY
MONDAY
TUESDAY
WEDNESDAY
THURSDAY
FRIDAY
SATURDAY

The values are not case-sensitive.

REPORT

Generates a report for the number of records extracted from each table since the last report was generated. The report represents the number of records output to the corresponding trail unless other reports are generated by means of the REPORT parameter.

Examples

Example 1   

The following ages trails every day at 3:00 p.m.

ROLLOVER AT 15:00

Example 2   

The following ages trails every Sunday at 8:00 a.m.

ROLLOVER AT 08:00 ON SUNDAY