Re: How drop tablespace if db in mounted mode
From: Aznable <termy_at_blunet.it>
Date: Mon, 30 Apr 2001 08:02:59 +0200
Message-ID: <3AED0013.A9BCE482_at_blunet.it>
Date: Mon, 30 Apr 2001 08:02:59 +0200
Message-ID: <3AED0013.A9BCE482_at_blunet.it>
> Hello all:
> I cannot open database (only mount) because, I believe, corrupted
> tablespace.
> How can I drop tablespace without opening database? Is it possible?
> Thank you
> Joseph
You cant :)
btw the tablespace cant b corrupted only datafiles can, so U have to put
offline
the corrupted datafiles, open the database and then drop the tablespace
if U havent a valid backup to recover corrupted datafiles.
Try to identify the corrupted files querying v$datafile_header, put
offline the datafiles
which have errores (there would be an ERROR column) and put them
offline.
I am sorry but at teh momento i havent documentation, nor oracle
database to give
you a more precise hint.
Ciao Received on Mon Apr 30 2001 - 08:02:59 CEST