| ORA-1652 error [message #194756] |
Mon, 25 September 2006 02:29  |
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  |
Shamsher
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 ;
Regards
Shamsheer
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
