Home » RDBMS Server » Server Administration » ORA-30928: Connect by filtering phase runs out of temp tablespace (Oracle,18.0.0.0.0, CentOS Linux release 7.6.1810 (Core))
ORA-30928: Connect by filtering phase runs out of temp tablespace [message #685253] Thu, 25 November 2021 22:38 Go to next message
BalajiDBA
Messages: 139
Registered: October 2018
Location: India
Senior Member
Hi,

Developer complaint that job is failing with below error i.e due to lack of space on temp tablespace.
ORA-30928: Connect by filtering phase runs out of temp tablespace 
So I added 25 GB space to the temp tablespace.But after adding 25 GB to the temp tablespace I found
file system size for the temp tablespace was 100% full.I have now dropped the tempfile which I added with size 25 GB.
After dropping the tempfile I found file system utilization was just reduced by 1% which is 99% utilized.

Kindly note that there is an automatic job that manages the temp tablespace size. ( Wasn't aware of this)

Could you please let me know how to fix this issue.

Regards,
Balaji

[Updated on: Thu, 25 November 2021 22:40]

Report message to a moderator

Re: ORA-30928: Connect by filtering phase runs out of temp tablespace [message #685254 is a reply to message #685253] Fri, 26 November 2021 00:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-30928: Connect by filtering phase runs out of temp tablespace
 *Cause:  It is probably caused by the fact that there is a loop in the data.
 *Action: Please retry the query with the NO_FILTERING hint. If the same error
          still occurs, then increase temp tablespace.
Re: ORA-30928: Connect by filtering phase runs out of temp tablespace [message #685255 is a reply to message #685254] Fri, 26 November 2021 00:25 Go to previous message
BalajiDBA
Messages: 139
Registered: October 2018
Location: India
Senior Member
Thank you Michel Smile
Previous Topic: Truncate SYS.AUD$ Using dbms_audit_mgmt
Next Topic: creating a sql plan baseline throws ORA-13846: Cannot create SQL plan baseline on the given plan
Goto Forum:
  


Current Time: Fri Mar 29 04:21:35 CDT 2024