ORA-1555/ORA-22924 error while export LOB objects

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Getting ORA-1555/ORA-22924 error while export LOB objects.




LOB objects are located in MSSM tablespace (Note 800386.1 ORA-1555 - UNDO_RETENTION is silently ignored if the LOB resides in a MSSM tablespace)

Modify the PCTVERSON of LOB segment to 50


Solution: alter table lobpctversion modify lob(lobLoc) (pctversion 50);




SQL> CREATE TABLE lobpctversion
(LOBLOC blob,id NUMBER)
LOB ( lobLoc ) STORE AS
(TABLESPACE users STORAGE (INITIAL 5k NEXT 5k PCTINCREASE 0) pctversion 5);

SQL> select table_name, segment_name, pctversion, retention
from dba_lobs where table_name in ('LOBPCTVERSION');

TABLE_NAME SEGMENT_NAME PCTVERSION RETENTION
----------------- --------------------------- ---------- ---------
LOBPCTVERSION SYS_LOB0000096861C00001$$ 5 10800

SQL> alter table lobpctversion modify lob(lobLoc) (pctversion 50);

Table altered.

Get Oracle Certifications for all Exams
Free Online Exams.com