OraFAQ Forum: Server Administration » question about tempfile

Home » RDBMS Server » Server Administration » question about tempfile

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

question about tempfile [message #155343]

Sat, 14 January 2006 01:49

raddisonlee
Messages: 29
Registered: March 2005

Junior Member

hi all !

there are a strange issue as follow:

SQL> select count(*) from dba_object_size;
select count(*) from dba_object_size
*
ERROR at line 1:
ORA-25153: Temporary Tablespace is Empty

but i comfirm that Temporary Tablespace is here ,
and a tempfile in it !!!!

SQL> SELECT * FROM USER_OBJECT_SIZE;

NAME TYPE SOURCE_SIZE PARSED_SIZE CODE_SIZE
------------------------------ ------------- ----------- ----------- ----------
ERROR_SIZE
----------
TIMES TABLE 0 3080 0
0

-----------------thanks you !

Report message to a moderator

Re: question about tempfile [message #155348 is a reply to message #155343]

Sat, 14 January 2006 03:19

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Are you sure that temporary tablespace with atleast one datafile exist??
Can you post the output from DBA_TEMP_FILES.

you can have a look here also.

http://www.orafaq.com/forum/t/55022/0/

Report message to a moderator