> I always thought that the only thing that should be in the SYSTEM
> tablespace is the objects owned by SYS. But it appears that,at least
> in some cases, these particular segments were created during DB
> creation, before one gets a chance to alter the defaults for these
> users.
>
> SELECT comments
> FROM ng_participants;
COMMENT
The SYSTEM tablespace should only contain data dictionary
objects.
This means those tables owned by SYS.
Oracle 10g improves this with the SYSAUX tablespace to store
things like OUTLN tables, AQ$ tables, etc.
HTH,
Brian
--
===================================================================
Brian Peasland
dba_at_remove_spam.peasland.com
Remove the "remove_spam." from the email address to email me.
"I can give it to you cheap, quick, and good. Now pick two out of
the three"
Received on Thu Apr 29 2004 - 15:46:17 CDT
