Home » RDBMS Server » Server Administration » extend temp tablespace
extend temp tablespace [message #57034] Thu, 15 May 2003 11:03 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
I'm running a query which has is returning large no. of columns with a group by and no order by. It's giving the following error message:

ERROR at line 27:
ORA-01652: unable to extend temp segment by 8192 in tablespace TEMP

I need to extend the temp tablespace temporarily

How can i identify the file name for the temp tablespace? I did a select * from dba_data_files and didn't notice and temp datafile.

Please help

Report message to a moderator

Re: extend temp tablespace [message #57035 is a reply to message #57034] Thu, 15 May 2003 12:57 Go to previous message
ctg
Messages: 146
Registered: July 2002
Senior Member
select * from dba_temp_files

Report message to a moderator

Previous Topic: about ora-29540
Next Topic: v$db_object_cache
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:48:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.