How does HVR deal with non-logged unrecoverable operations (like direct-path inserts (insert /*+ APPEND */) above the HWM into “NOLOGGING“ tables)?

Viewing 1 post (of 1 total)
  • Author
  • #10965

    HVR does support capture of direct-path/append-hint/parallel inserts to regular tables, but ones into NOLOGGING tables are not supported.

    When a direct path operation is performed on a table that has NOLOGGING defined (and the database is not in a force logging mode) then generally the changes are silently ignored. Obviously, these direct path changes in Oracle are not recoverable. If direct path operations on tables with NOLOGGING occur on the source (and they can’t be avoided) then you could consider scheduling online refresh after they happen.

Viewing 1 post (of 1 total)
  • The forum ‘Expert Notes’ is closed to new topics and replies.

© 2020 HVR

Test drive Contact us