Error while loading xsd as external defination in IR

[Former Member]

Hi,

When I try to create external definition from XSD,

it gives following error

"ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP"

This happens when I try to save any XSD.I am sure there is no problem with XSD.

Did anyone come accross this problem?

Thanks

Sachin K

[Former Member · Accepted solution]

hi

this is purely a basis issue.

xi db tablespace is over.

ask your basis to extend the table storage space.

rgds,

Arun

[Former Member · Accepted solution]

As said by Arun it is an issue with internal oracle tables.

See this note : 1186364

Here is the encapsulated details of the above sap note :

Symptom 


Siebel GDQL

Siebel GDQL 2.11c

Siebel GDQL 2.00c

ORA-01652

Unable to extend temp segment by 128 in tablespace TEMP '

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP '

ActivateInputFields::ExecuteQuery Failure. Msg: 'An error has occurred executing a Sql statement.

Error: ActivateInputFields::ExecuteQuery Failure. Msg: 'An error has occurred executing a Sql statement. Please continue or ask your systems administrator to check your application configuration if the problem persists.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP '



Resolution 
This is an Oracle error. The TEMP tablespace will need to be increased (change the file name and size as appropriate.)

For example: The SQL command to do that will look similar to:
alter database datafile 'e:\oracle\oradata\hor7\siebel_temp.dbf' resize 2000M;

Thanks

farooq.

[Former Member]

>ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

Its seems an internal problem with your Oracle Database (that XI is using.)

Thanks

Farooq