Re: System Tables in User Tablespace???

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/25
Message-ID: <956637852.22975.0.pluto.d4ee154e@news.demon.nl>#1/1

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