Re: System Tables in User Tablespace???

To rephase the question, Do all objects owned by user-'system' belong in the
system tablespace as vs the User_Data tablespaces??

These tables which really have no rows in them, are clearly owned by the User- 'System'

Shall I move them into their own tablespace or delete them from the User_Data tablespace?

I am running OEM also, I think these tables belong somewhere else and were created
from a script that was run by mistake by another user/schema.

"W. Scott Moore" wrote:

> You should be able to go in with Repository Manager and choose to remove the
> repository.
>
> Scott
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:956637852.22975.0.pluto.d4ee154e_at_news.demon.nl...
> > These tables are the Oracle Enterprise Manager repository.
> > Ideally you shouldn't use the system account for this.
> > There is an utility to delete them included with OEM, I don't exactly
> > remember where.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > Scott W. Patterson <swpatterson_at_mindspring.com> schreef in berichtnieuws
> > 39050BE0.E5058287_at_mindspring.com...
> > > I have found some 18 tables that are owned by System that are currently
> > > in the User data tablespaces, all the tables begin with SMP or SM
> > >
> > > such as SMP_LANG_TEXT
> > > SMP_REP_VERSION
> > > SMPCONFIGERATION
> > > SMP_BRM_CHANNEL_DEVICE_
> > > SMP_BRM_DEFAULT_CHANNEL_
> > > SMP_VAB_ACTIVE_JOB_
> > > SMP_VAB_SAVED_JOB
> > > ECT
> > >
> > > Should I move these into the system tablespace, or are they part of
> > > some DBMS utility packages.? They possible were created by a developer
> > > that meant to create these in the System schema all of these objects
> > > were created a few months ago
> > > December 99 when a developer was working on our database.
> > >
> > > Any suggestions??
> > >
> > > Thanks
> > >
> > > Scott Patterson
> > >
> >
> >
Received on Tue Apr 25 2000 - 00:00:00 CDT