Drop tablespace that has raw devices and reuse the raw devices
JJ2Jul 11 2011 — edited Jul 11 2011Hello,
This is a scenario which I've never got an opportunity to test.
I got a tablespace IDX, it is 5G large and built on 5 x 1 GB raw devices.
I need drop this tablespace (after dropping all indexes), re-create the same IDX tablespace using just about 2 raw devices ( 2 GB in total), now I should have 3 x 1 GB raw devices left.
I like to expand an existing DATA tablespace with this 3 x 1 GB raw devices that got freed up in the last step.
When you issue SQL> DROP TABLESPACE IDX; -- (all the objects in the tablespace have already been dropped) would the database disassociate the raw devices from the system and let me reuse the raw devices in the DATA tablespace (would I need to use the reuse clause).
I've done this many times in file systems but never tried with raw devices.
Mine is a 9iR2 database.. Please share your experience.