› › Oracle Temp Space Database error;Unable to extend temp segment in tablespace

Oracle Temp Space Database error;Unable to extend temp segment in tablespace


Scenario:

Inbound x12 856 (ASN) is received and translated into JDEdwards E1 tables via SQL Insert (Database Adapter).

Issue:

Oracle DBA allowed the Production business data tablespace to fill-up

EXTOL error message:


Error Instance 1:


Nested SQLException:
Message : ORA-01653: unable to extend table PRODDTA.F5547002 by 8192 in tablespace PRODDTAT
State : 72000
Error Code : 1653
Stack trace: java.sql.SQLException: ORA-01653: unable to extend table PRODDTA.F5547002 by 8192 in tablespace PRODDTAT

Error Instance 2:


EXTOL EBI SQL Insert Error Temp Space Database error;Unable to extend temp segment in tablespace TEMP

Resolution:

EXTOL users need to contact DBA to mitigate issue and extend disk space in the Oracle Database. While issue is being worked on, EXTOL EBI users might want to suspend/stop inbound/outbound transactions.
By: on
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.