Home » SQL & PL/SQL » SQL & PL/SQL » ORA 01555
ORA 01555 [message #190193] Tue, 29 August 2006 11:25 Go to next message
sweetgeegee27
Messages: 107
Registered: June 2005
Senior Member
I know that this has to do with rollback segments. What do I need to do and where can I find the UNDO_RETENTION option?
Re: ORA 01555 [message #190204 is a reply to message #190193] Tue, 29 August 2006 12:39 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
select * from v$parameter
 where name = 'undo_retention';
Previous Topic: materialized view
Next Topic: Bulk Collect & Pipelined Table Function - Confusion Building
Goto Forum:
  


Current Time: Sun Aug 20 21:37:34 CDT 2017

Total time taken to generate the page: 0.09187 seconds