Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reducing System Tablespace Size
On Wed, 07 Oct 1998 22:11:16 -0700, sooz <sooz_at_pobox.com> wrote:
>What do mean Oracle is the only person/thing ... shouldn't the SYS and
>SYSTEM users use the default tablespace of SYSTEM??
For a well managed database, the user SYS should be the only schema having objects reside in SYSTEM tablespace. All other users, including SYSTEM, should have default and temporary tablespace set to some other tablespace at their creation time or imediately after that.
Generaly, only the system rollback segment and the segments constituting the database dictionary should be held in SYSTEM tablespace.
For user SYSTEM the usual deafult tablespace is named TOOLS.
>Does this 'resize' work in version 7.1.6 too?
No, it doesn't. This feature was introduset in 7.2.
>I recently took over a database that had been administered by users and
>practically all the applications objects (unknowingly) were created in
>the SYSTEM tablespace. Apparently they just kept adding data files as
>needed. I think there are four files defining SYSTEM now. I've since
>moved all the segments into other tablespaces and now would like to
>resize SYSTEM to something more reasonable for its purpose.
"Export -> recreate the database -> import" seems to be the only option for your version.
>Thanks.
>- sooz
HTH,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)