First page Back Continue Last page Graphics
…Data Pump Features…
Flashback support
- Export at previous point in time
- Get a consistent export
- See FLASHBACK_SCN and FLASHBACK_TIME parameters
Notes:
Datapump supports flashback query.
On export, specify the SCN or time you want the data to be consistent with. Of course, all flashback query rules apply, e.g. sufficient UNDO must be available, you cannot flashback beyond last DDL time, etcetera.
Flashback is even supported on network imports! (More on network imports later in this lesson.)