Originally posted by Mnemonical
If I use locally managed tablespaces, why should I set storage parameters for rollback segs?
F
Because "Locally Managed RBS Tablespace" and "Automatic Undo Management" are two different concepts.
Creating your rollback tablespace as LMT doesn't mean that you are using AUM. You still need to create rollback segments even you are using LMT. But if you are using AUM you just create a UNDO tablespace. Set UNDO_MANAGEMENT, UNDO_RETENTION and you are done. You do not need to create any rollback segments.
Last edited by SANJAY_G; 01-16-2003 at 11:26 PM.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Reply With Quote