PL/SQL (MOSC)

MOSC Banner

REDOLOG divide in two lines large VARCHAR

edited Mar 2, 2021 11:32AM in PL/SQL (MOSC) 6 commentsAnswered

Hello,


I'm making a PL/SQL redo log analyzer. When I use LogMiner to analyze a table that contains a large varchar, the redo log divide my INSERT in that table in one INSERT + one UPDATE. Let's see a sample:


I execute these SQL lines:

CREATE TABLE DUMMY (ID NUMBER, VARCHAR_LARGE VARVHAR2(32767));

INSERT INTO DUMMY (ID) VALUES ('1');

commit;


Then I execute LogMiner to view the SQL lines executed and the result is:

INSERT INTO DUMMY (ID, VARCHAR_LARGE) VALUES ('1', 'LM_EMPTY_STRING');

UPDATE DUMMY SET VARCHAR_LARGE=NULL WHERE ID='1';


What is the reason to split in two lines when I just execute an INSERT?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center