Re: Can I safely get rid of the EXAMPLE tablespace?

From: ohaya <ohaya_at_cox.net>
Date: Sat, 21 Jan 2006 23:48:49 -0500
Message-ID: <43D30EB1.D1311827@cox.net>

Ravi Chandran wrote:
>
> hi, sure you can get rid of 'EXAMPLE' database. Simply drop it..:)
> "ohaya" <ohaya_at_cox.net> wrote in message news:43C4BE86.ADDA4D3_at_cox.net...
> > Hi,
> >
> > I used DBCA to create a "general" database, and I noticed a large
> > (~150MB) tablespace named "EXAMPLE".
> >
> > Can I safely get rid of that tablespace (to get the 150MB back)? If so,
> > what's the easiest way to accomplish that?
> >
> > Thanks,
> > Jim

Hi,

Per suggestions on this thread, I took took the tablespace offline on about 1/11/06.

Everything seemed to be going ok, but I got a popup warning just now (I'm running Windows 2000 Server SP4) saying that the Application Log in Event Viewer was full.

I looked at Event Viewer, and it looks like there have been a pair of Warning followed by Information events logged about every 45 seconds since at least 1/15/06:

Event Type:	Warning
Event Source:	Oracle.portal
Event Category:	None
Event ID:	16
Date:		1/15/2006
Time:		11:13:30 PM
User:		N/A
Computer:	JIMNEW

Description:
Instance portal has been terminated.

Event Type:	Information
Event Source:	Oracle.portal
Event Category:	None
Event ID:	5
Date:		1/15/2006
Time:		11:14:17 PM
User:		N/A
Computer:	JIMNEW

Description:
Initializing PGA for process QMN0 in instance portal.

I can't tell if these started after I offlined that tablespace or not, because that was the beginning of the event viewer log on 1/15.

I'm going to un-offline the tablespace, and see if the msgs stop, but has anyone seen this behavior before?

Thanks,
Jim Received on Sat Jan 21 2006 - 22:48:49 CST