ORA-1652 non TEMP tablespace with INSERT & INDEX build free space fine
PktAcesJun 18 2012 — edited Jun 18 201210.2.0.5 Ent Ed RHEL
I've got an issue with an informatica workflow causing ORA-01652 errors on two different index builds and one insert statement in a permanent tablespace.
INSERT /*+ SYS_DL_CURSOR */ INTO owner1.table1("col_a","col_b") VALUES (NULL,NULL);
initial ext = 64k next ext 1M, size 20M
create unique index index_ux on table_c (col_a, col_b)
initial ext = 64k next ext 1M, size 2M
create unique index image_lkp_scrid_ux on image_lkp_scrid (image_id, scrid)
initial ext = 64k next ext 1M, size 6M
the schema owner's default temp tablespace is set to use TEMP. I understand the need for temp space in the permanent tablespace for index builds, but I'm not so sure why for the insert.
There is over 2G of continous free space in the tablespace that these objects reside in, the tablespace is a LMT and set to ASSM.
What am I overlooking as far as to why this would be causing ora-1652 ?