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 08, 2017

Applies to:

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

Symptoms

On : 9.3.0.2 version, Searches

ACTUAL BEHAVIOR
---------------
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

EXPECTED BEHAVIOR
-----------------------
Advance search could find PCO data with affected price attribute

STEPS
-----------------------
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'.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms