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: Session users
Next Topic: How to run the Single Server Multiple instance and Multiple database?
Goto Forum:

Current Time: Sat Aug 19 08:16:35 CDT 2017

Total time taken to generate the page: 0.06088 seconds