Hi Lists;
Our issue:
A disk crashed in a database, that is a warehouse ( is in NOARCHIVE mo=
de),
in this disk we had only 6 datafiles that have only one table with old
information. We did:
- Startup mount only , and ...
- alter database datafile 'filename' offline drop
in each datafile.
Now, the database is up and OK, but the "drop" didn=B4t work. The
datafiles remains in the dictionary and the space is "allocated";
I means, for oracle, the tablespace have 120 GB , but 20 GB (the
crashed disk) doesn=B4t exist. We want to use the same name for
the news datafiles, but we can=B4t. We want to drop the ghosts
datafiles and put free the wrong allocated space .
Oracle support said: you have to re-create the tablespace and
then, create the datafiles again ...
This job is very complicated (remember, 120 GB and without free space
in others disks)
How can I drop the datafiles easily?
SO: Digital Alpha 4d , Oracle 8.0.5.1.1
Thanks in advance ...=
Received on Wed Dec 13 2000 - 09:11:29 CST
