ORA-30036 occurs when TRUNCATE GeoRaster data table
(Doc ID 2936894.1)
Last updated on MARCH 30, 2023
Applies to:
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]Oracle Spatial and Graph - Version 19.1.0.0.0 and later
Information in this document applies to any platform.
Goal
ORA-30036 occurs when TRUNCATE GeoRaster data table.
Why use many UNDOs when TRUNCATE?
SQL> desc tab1
Name Null? Type
----------------------------------------- -------- ----------------------------
col1 NOT NULL NUMBER
col2 PUBLIC.SDO_GEORASTER
col3 PUBLIC.SDO_GEORASTER
col4 PUBLIC.SDO_GEORASTER
col5 PUBLIC.SDO_GEORASTER
col6 PUBLIC.SDO_GEORASTER
col7 PUBLIC.SDO_GEORASTER
col8 PUBLIC.SDO_GEORASTER
col9 PUBLIC.SDO_GEORASTER
col10 PUBLIC.SDO_GEORASTER
col11 PUBLIC.SDO_GEORASTER
col12 PUBLIC.SDO_GEORASTER
col13 PUBLIC.SDO_GEORASTER
col14 VARCHAR2(4000)
SQL> truncate table tab1 DROP STORAGE;
truncate table tab1 DROP STORAGE
*
ERROR at line 1:
ORA-04088: error during execution of trigger 'TEST01.SDO_GEOR_ADDL_TRIGGER'
ORA-00604: error occurred at recursive SQL level 1
ORA-30036: unable to extend segment by 128 in undo tablespace 'UNDOTBS1'
ORA-06512: at "MDSYS.SDO_GEOR_AUX", line 309
ORA-06512: at "MDSYS.SDO_GEOR_AUX", line 227
ORA-06512: at "MDSYS.SDO_GEOR_AUX", line 219
ORA-06512: at line 1
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |