Yes, it is a good idea to create all tablespaces (except SYSTEM of course) as
locally managed in 8i. The only caveats are to keep the number of extents per
object well below (db_block_size / 16) - 7, and to avoid intensive use of the
DBA_SEGMENTS and DBA_EXTENTS data dictionary view families.


-----Original Message-----
Sent: Saturday, 26 August 2000 6:16


I was wondering if it is a good idea to create TEMP and ROLLBACK tablespaces as
locally managed tablespaces in oracle 8i.