OraFAQ Forum: Server Administration » ORA-30928: Connect by filtering phase runs out of temp tablespace

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))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-30928: Connect by filtering phase runs out of temp tablespace [message #685253]

Thu, 25 November 2021 22:38

BalajiDBA
Messages: 133
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

Michel Cadot
Messages: 68501
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.

Report message to a moderator

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

BalajiDBA
Messages: 133
Registered: October 2018
Location: India

Senior Member

Thank you Michel Smile

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 13:58:52 CDT 2023