From: plovmand@hotmail.com (Kenneth Koenraadt) Newsgroups: comp.databases.oracle.server Subject: Re: Locally Managed Tablespaces - any cons??? Message-ID: <3b7197c5.7098447@news.mobilixnet.dk> References: X-Newsreader: Forte Free Agent 1.11/32.235 Lines: 29 Date: Wed, 08 Aug 2001 19:54:11 GMT NNTP-Posting-Host: 212.97.246.137 X-Complaints-To: abuse@orangedk.com X-Trace: news.mobilixnet.dk 997300657 212.97.246.137 (Wed, 08 Aug 2001 21:57:37 CEST) NNTP-Posting-Date: Wed, 08 Aug 2001 21:57:37 CEST Organization: Mobilix Internet -- http://www.orangedk.com/ On Tue, 7 Aug 2001 21:20:37 -0600, "Ron Gardiner" wrote: >New for 8i (I believe) is locally managed tablespaces... > >From what I've read, sounds like there is no reason NOT to use them. Can >they be used for all types of TS?... rollback segs, temporary, how about >system itself? > >Any feedback would be appreciated! > > > Hi Ron, You cannot create a locally managed SYSTEM tablespace on database creation. But you can convert it to LM later with a supplied package. The SYSTEM tablespace and the tablespaces for rollback segments must have the same extent management type, so if you convert the SYSTEM Tablespace to LMT, rememer to convert your RBS tablespace(s) to LMT as well. Regards, Kenneth Koenraadt Systems Consultant Oracle DBA plovmand@hotmail.com