Home » RDBMS Server » Performance Tuning » oracle error 35153 temporary tablespace is empty
oracle error 35153 temporary tablespace is empty [message #228227] Mon, 02 April 2007 02:31 Go to next message
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
Re: oracle error 35153 temporary tablespace is empty [message #228232 is a reply to message #228227] Mon, 02 April 2007 03:09 Go to previous message
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: Fri Dec 02 16:55:27 CST 2016

Total time taken to generate the page: 0.31982 seconds