| Neeraj |
Posted: Mar 31, 2008 07:52:08 AM |
Total Post: 231
Joined: Jan, 2007
|
hi,
i m getting error snapshot too old on my oracle database.
my temp file was set unlimited size ,now i dont hav size on my disk.
then how to resolve it.
|
|
|
 Mohammed Taj |
| Posted: Mar 31, 2008 09:33:53 AM |  |
|
Total Post: 704
Joined: Jul, 2007
|
Neeraj,
It is very famous error. ORA-01555 which your getting.
did you try to search on google.?
It is not related to TEMP tablespace.
increase UNDO tablespace size or set properly undo_retention parameter.
just search on google for ORA-01555
|
|
|
|
|
| simmah |
| Posted: Apr 01, 2008 12:58:48 AM | |
|
Total Post: 2
Joined: Feb, 2008
|
hai , first to be very clear , snap shot too old error ie) 0ra1555 error doesnt caused by temp file , this is the error msg caused by undo tablespace , when it affects the read consistancy it will throw this error , what u have to do is simply increase the size of the undo tablespae either by resize or u can add a datafile to the undo tablespace . this is the more relevant resolution.
|
|
|
|
|
| Neeraj |
| Posted: Apr 01, 2008 01:03:31 AM | |
|
Total Post: 231
Joined: Jan, 2007
|
i have mentioned that i dont have size on my disk.so cant increse unto tablespcae.
my temp tablespace has occupied all size, so i need to recreate or resize temp file, so i can hav some space on my disk then i can increase undotablespace.
so i just want to know how to make new temp or resize temp tablespace ?
setp by step.
thxs
|
|
|
|
|
| Murtuja |
| Posted: Apr 01, 2008 05:31:56 AM | |
|
Total Post: 815
Joined: Jan, 2006
|
Hi
Q: how to resize temp tablespace?
http://www.idevelopment.info/data/Oracle/DBA_tips/Tablespaces/TBS_3.shtml
HTH
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
