Re: HELP ME TO DROP REPOSITORY OBJECTS

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)