Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Undo space
Have you thought of this one ;)
undo_retention_time = 45 minutes.
Why do I get an ora-01555 once a year
towards the end of march ?
-- Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases See http://www.jlcomp.demon.co.uk/book_rev.html For latest news of public appearances See http://www.jlcomp.demon.co.uk Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. Pete Sharman wrote in message ...Received on Mon Aug 20 2001 - 11:33:18 CDT
>Ah yes, but they're now automatically managed for you!
>
>Undo segments is the term used in 9i for automatically managed rollback
>segments. Management of the undo segments is handled internally by Oracle
>and all you need to do is specify the tablespace name. The tablespace is
>created with the CREATE UNDO TABLESPACE command after the database is
>created or with the UNDO TABLESPACE clause for the CREATE DATABASE command.
>