RMAN duplicate database problems

Hi Chucks

Try this

Mount the database
drop the tablespace including contents
open the database

regards
Hrishy

Hi Hrishy,

I didnt think you could drop a tablespace whilst the db is in mount state. I tried it anyway:

Code:

---

SQL> drop tablespace HLMUR_2008_03_03 including contents;
drop tablespace HLMUR_2008_03_03 including contents
*
ERROR at line 1:
ORA-01109: database not open

---

Any thing I have done wrong?

If I'm Oracle I wouldn't be happy if somebody tries to drop a tablespace containing some table partitions but not all of them.

Hi

Try this
startup mount
alter database datafile 'complete path' offline drop;
alter database open
drop tablespace table-space-name including contents

regards
Hrishy

Check also if you fall in the condition mentioned by PAVB

regards
Hrishy

Hi all,

Thanks for all your help. I managed to solve the problem by exchanging the partitions from the 'dud' tablespaces in temporary tables and also rebuild the the index partitions into another tablespace. I was then able to drop the missing tablespaces.

Thanks again.
Chucks