Oracle Database Discussions

Hello to all

My database has bigfile undo tablespace that is autoextended and is retention guarantee
and my disk has enough space

undo_retention is equal 1800 when I execute

select *
from mdb.trde VERSIONS BETWEEN TIMESTAMP
to_timestamp('08/11/2008 22:01:00','dd/mm/yyyy hh24:mi:ss') and
to_timestamp('08/11/2008 22:02:00','dd/mm/yyyy hh24:mi:ss');

I recieve ora-30052 error when i increase undo_retention to 172800 the query
executes fine

but while undo_retention=172800 I execute

select count(*)
from mdb.trde VERSIONS BETWEEN TIMESTAMP
to_timestamp('08/11/2008 22:01:00','dd/mm/yyyy hh24:mi:ss') and
to_timestamp('08/11/2008 22:02:00','dd/mm/yyyy hh24:mi:ss');

I recieve ORA-01555 error, even I set undo_retention=2147483648 I recieve that error too

I expect since the undo tablespace is autoextended and retention quarantee, it increased and I don't
recieve ORA-01555 but it don't happened

do you know what is problem?

thanks

Edited by: ARKH on Nov 9, 2008 3:12 AM