Home » RDBMS Server » Server Administration » ORA-1652 error
ORA-1652 error [message #194756] Mon, 25 September 2006 02:29 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
I am having an error in alert file
ORA-1652: unable to extend temp segment by 128 in tablespace
can anybody help me where is the problem?
and what i have to do now to avoid this error
Re: ORA-1652 error [message #194763 is a reply to message #194756] Mon, 25 September 2006 03:18 Go to previous message
Messages: 18
Registered: September 2006
Junior Member
Query on V$temp_space_header to know the usage of tempfile if its full add tempfile to the temporary table space. You can use below command for ref.

Alter tablespace temp add tempfile 'c:\oradata\temp01.dbf' size 1024k ;

Previous Topic: AS9i
Next Topic: SQLPLUS coredump on HP-UX
Goto Forum:

Current Time: Wed Oct 26 08:51:10 CDT 2016

Total time taken to generate the page: 0.08441 seconds