How to modify a the PCTVERSION for a LOB segment?

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

Problem Description: alter table ecs.CS_B_DOCUMENT MODIFY LOB SYS_LOB0000356268C00007$$ (PCTVERSION 50);

ERROR at line 1:
ORA-00902: invalid datatype


Main Issue:


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)

Have advised customer to modify the PCTVERSON of LOB segment to 50 but it failing with the following error:


alter table ecs.CS_B_DOCUMENT MODIFY LOB SYS_LOB0000356268C00007$$ (PCTVERSION 50);

ERROR at line 1:
ORA-00902: invalid datatype


Solution by Example: 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