Re: Drop Database.

From: rok <rthumsi_at_cncx.com>
Date: 30 Aug 1998 23:40:34 PDT
Message-ID: <01bdd4aa$54223a20$66b59bcf@thumsi95.cncx.com>

If all that is corrupted is rollback segment, then just drop the tablespace containing the rollback segment and recreate it. It is much easier than recreating entire database.

raghuvir

Sanjeev Singh <sanjeev_at_pacbell.net> wrote in article <35E9E794.7E43_at_pacbell.net>...
> Hi,
>
> I have a corrupted data block in Rollback segment. I was able to take
> full export. I am trying to drop my database. Can anyone tell me right
> syntax to drop the database, then i can create new dB and import the dmp
> file.
>
> Thanks,
>
Received on Mon Aug 31 1998 - 01:40:34 CDT