Re: System Tables in User Tablespace???

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