Re: Undo space

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 20 Aug 2001 17:33:18 +0100
Message-ID: <998325007.4415.0.nnrp-13.9e984b29@news.demon.co.uk>

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 ...


>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.

>

Received on Mon Aug 20 2001 - 11:33:18 CDT