p_publish_04: ORA-01691: unable to extend lob segment
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
Running p_publish_04 we get the following error in publish_04.xml_err.n.n log files:
Error: write_xml_to_clob: ORA-01691: unable to extend lob segment ABC50.Z00P_SEGNAME by 16384
What is the recommended settings for ABC50 file_list for Z00P?
util o/14/1
TABLESPACE_WITHOUT_FREE_SPACE
------------------------------
TS4D
******************************************************
abc50 file_list:
Z00P is using TS4D
TAB z00p 4M 1M TS4D
IND z00p_id 100K 100K TS3X
IND z00p_id1 100K 100K TS3X
IND z00p_id2 100K 100K TS3X
IND z00p_id3 100K 100K TS3X
IND z00p_id4 100K 100K TS3X
SEQ last_publish_seq
***********************************************************
abc50
util a/17/11/2 for z00p shows:
Enter Table/Index Name: z00p
TABLE_NAME = Z00P
check = ABC50
active_library = ABC50
BYTES/1024 BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT
---------- ---------- ---------- -------------- -----------
262144 32768 2 4194304 134217728
Elapsed: 00:00:00.33
COUNT(*)
----------
1157547
Resolution:
DBA added 4GB extend-able to 8GB for ts3d_13.dbf
We still ran out of space.
DBA added (two) 8g datafiles each extend-able to 16g and that was enough space.
We don't know why TS3D needed so much space.
Summary:
Aleph had 24 GB (2GB x12) initially
DBA added 4GB extend-able to 8GB (ran out of space) ts3d_14.dbf
added 8GB extend-able to 16g ts3d_15.dbf
added 8GB extend-able to 16g ts3d_16.dbf
total: 64GB
Note: DBA did not use util o/13/3
Aleph util o/13/1 does not show ts3d_14.dbf, ts3d_15.dbf, ts3d_16.dbf since he added them from oracle backend.
He wanted to make the datafiles extend-able - grow as needed
Growing TS3D to 64GB allowed Publish_04 to finish.
- Article last edited: 10/8/2013