OraFAQ Forum: Performance Tuning » oracle error 35153 temporary tablespace is empty

Home » RDBMS Server » Performance Tuning » oracle error 35153 temporary tablespace is empty

Mon, 02 April 2007 02:31

namrata_bhise
Messages: 18
Registered: October 2006
Location: mumbai

Junior Member

Hi,

While taking database backup I am getting error oracle error 35153 temporary tablespace is empty.

Regards
Namrata

Mon, 02 April 2007 03:09

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Can you post below query output.

select name from v$tempfile;

if query return "no rows" then you should to add TEMPFILE in temporary tablespace.

regards
Taj

Previous Topic:	Forms Performance
Next Topic:	Query regarding deleting the reords from DB

Goto Forum:

]

Current Time: Wed Jan 14 22:24:13 CST 2026