BMC Remedy User Application 7.1.00 patch 004
CI search
I have one Asset form, out of 26, that I cannot perform an unqualified search on - it results in an error "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP".
If I search for a specific CI by name its fine but as soon as I try any form of wildcard or unqualified search I hit problems
Using sqldeveloper I can extract all data in no time at all
There are only 133 records in the table.
Other Asset tables have 20K plus records and can have an unqualified search run and return results in seconds

Can anyone suggest where to begin with the rogue table

Seems to be a problem In Asset management as if I open the form from a CTRL+O I can perform the unqualified search - hey ho

One effective way to find out what workflow and form fields may cause the error is to turn logging. Then upload the log to www.arvitals.com, it a free site for analyzing AR log and AR Definition files.