Can a SYSTEM tablespace be locally managed.

2001-08-16 Thread Cale, Rick T (Richard)
Hi DBAs, I have ready many conflicting notes on MetaLink whether or not a SYSTEM tablespace can be locally managed. Most of the article state definitely not in 8.1.6 and less. While others say Yes and No in 8.1.7 Anyone know for sure thru actual use. Thanks Rick -- Please see the official

Re: Can a SYSTEM tablespace be locally managed.

2001-08-16 Thread Jonathan Lewis
Since you are likely to get conflicting answers from the list, how are you going to decide ? At present there is no syntax line in CREATE DATABASE for making the system tablespace locally managed, which is a hint. The other hint is that the Oracle 9 Concepts manual (Ch 4 page 10) states

Re: Can a SYSTEM tablespace be locally managed.

2001-08-16 Thread Rachel Carmichael
it can't From: Cale, Rick T (Richard) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Can a SYSTEM tablespace be locally managed. Date: Thu, 16 Aug 2001 08:28:22 -0800 Hi DBAs, I have ready many conflicting notes on MetaLink

RE: Can a SYSTEM tablespace be locally managed.

2001-08-16 Thread Page, Bruce
Subject: Can a SYSTEM tablespace be locally managed. Hi DBAs, I have ready many conflicting notes on MetaLink whether or not a SYSTEM tablespace can be locally managed. Most of the article state definitely not in 8.1.6 and less. While others say Yes and No in 8.1.7 Anyone know