Re: Tablespace DRSYS

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 16 Apr 2002 18:43:42 +0200
Message-ID: <3CBC54BE.1F729D57@mytoys.de>

> Most of them are empty:
> USERS
> INDX
> OEM_REPOSITORY
> So I put them offline to see if somebody complains, and I will drop
> them soon.
>
> I've seen that there is a DRSYS tablespace with some segments inside,
> all of them owned by a user called ctxsys.

You can drop them immediately, also SYSTEM, TEMP and RBS (just kidding).

Honestly, you know how to put a tablespace offline but don't know what those tablespace are for?

USERS: default tablespace for all users but some internal users (e.g. system) INDX: all indexes should go there by default OEM_REPOSITORY: the repository off Oracle Enterprise Manager resides here DRSYS: If you user the context server Oracle will store the information there

Look at dba_users what default tablespace your database users have. Or do you use only system or sys to connect to the database?

Regards,

Knut Received on Tue Apr 16 2002 - 11:43:42 CDT