Re: drop something ?

From: Julio <julio.negueruela_at_si.unirioja.es>
Date: Tue, 21 Jul 1998 12:46:55 +0200
Message-ID: <35B4719F.EECED477@si.unirioja.es>

sor escribió:
> =

> Could I drop and recreate temp & rbs tablespaces...?
> And what should I take care ?

When dropping a temporary tablespace you must review the temporary tablespace of all users whose temp tablespace pointed to it.

To drop and recreate any rbs tbsp, ensure that no rbs allocated here doesn't "support" (oh, my horrible English) any active transactions. You must do so:

Drop the rollback segments manually.
Ensure there will be enough rollback segments in other tablespaces. Drop the tablespace.
Re-create it.
Create the same rollback segments.

> sor
> --
> E-Mail : ymy0_at_www.dab.com.tw

Hope this help.
-- =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Tue Jul 21 1998 - 05:46:55 CDT