This time i would like to address a common error in an uncommon situation. The exact reason for this issue is not known to me, probably somebody in the comments could let me know.
PROBLEM:
If you have extended a Siebel table in Siebel tools or created a new column or altered any other table child attributes, you would like to perform Apply/DDL and then would expect the change to be on database.
Well in doing so, you may face an error: "S1000 (1652): [tp][ODBC Oracle driver][Oracle]ORA-01652: unable to extend temp segment by 128 in tablespace USERS". This error is common when creating a huge table or index in USER tablespace in database, since an individual user tablespace typically consist of less space which is allocated by the DBA. But while applying the change in database through Siebel tools, this error is quite rare.
Below are some screenshots after which you can possibly get this error:
Error: "S1000 (1652): [tp][ODBC Oracle driver][Oracle]ORA-01652: unable to extend temp segment by 128 in tablespace USERS"
RESOLUTION:
The solution to avoid this error is very simple. Just mention the default Siebel tablespace in the "Index space" property as shown below. In this case it is "SIEBINDX". And click on Apply.
Keep Reading
Mohammed Arif
