My Oracle Support Banner

Error: 'ORA-01652: Unable to Extend Temp Segment by xxx in Tablespace TEMP' When Running Searching With Affected Price Attribute (Doc ID 1595041.1)

Last updated on AUGUST 26, 2020

Applies to:

Oracle Agile PLM Framework - Version to [Release 9.3]
Information in this document applies to any platform.


On : version, Searches

When searching for PCO, and display affected prices attributes, search result is blank
Receiving error 'ORA-01652: unable to extend temp segment by 256 in tablespace TEMP' in java client

Advance search could find PCO data with affected price attribute

The issue can be reproduced at will with the following steps:
1. Create a new advance search as below:
  "workflow" not in "Default Price Change Order" AND
  "Nunber" does not start with "x" AND
  "status " not in "$STATUSTYPE.RELEASED"
2. Found 9 rows in search result.
3. Add following affected price attributes into format
  > Item Number
  > Item Rev
  > Mfr Name
  > Manufacturer Part Number
  > Price Type
  > Price Number
  > Supplier
4. Run the search again.
5. No any data could be found.

6. Run the search from Java client but get this error 'ORA-01652: unable to extend temp segment by 256 in tablespace TEMP'.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.