I remember there was a tools with Oracle 8.0 with allowed to drop EM
repository...
"Daniel Morgan" <damorgan_at_exxesolutions.com> a écrit dans le message de
news:3EBA7514.1875A476_at_exxesolutions.com...
> HP Support wrote:
>
> > Hi,
> >
> > I noticed in our SYSTEM tablespace some tables beginning with EVT_ and
> > SM ( SMP_ , etc.); the owner of these tables is the user SYSTEM . Can I
> > drop these tables and how can I do it?
> >
> > Thanks in advance
> >
> > Domenico
>
> Why? Why would you even consider this long enough to ask the question?
What
> would you expect to gain if someone said Yes to you?
>
> If the point is to destroy your Oracle installation and its associated
> tools by all means do so.
>
> You should not be logged on as either SYS or SYSTEM for any reason other
> than maintenance with a specific purpose in mind. Ratting around looking
> for stuff to drop is not a specific purpose. And even if you do so and
> don't damage the system (which you will do in this case) you will
> accomplish nothing as you can not recover the space and reuse it. The
> SYSTEM tablespace is reserved for SYS and SYSTEM ... as I said already ...
> and you should not be there.
>
> BTW: If it ain't broke don't fix it!
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Thu May 08 2003 - 19:34:59 CDT
