Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002

    Unanswered: Is Oracle logs BLOB-s?

    My env is Oracle 9.2.04. RAC and I have to work with LOB-s maxsize 2M.
    Is Oracle "saves" LOB in redo log (and archived logs) so it can be recreated with restore and recover?
    If answer is No:how can it be done?Is it can bi done?

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    When defining LOBs in a table, you can specify the tablespace and storage characteristics for each internal LOB. I guess LOGGING (and NOLOGGING) might be interesting for you. Read a little bit more about it here.

    Shortly, when LOGGING is set, Oracle generates full redo for LOB data pages.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts