Unable to drop tablespace

[Former Member]

Hello Gurus,

I encountered with the error ora-14405 (i.e partitioned index contains partitions in different tablespace)  while dropping an empty tablespace...

please suggest a solution..

Thanks in advance.

regards,

pavan

[Reagan]

Are you using BR*Tools to drop the tablespace ?

Which tablespace are you trying to drop ?

Regards

RB

[Former Member]

yes RB,

I am using BR* tools to drop PSAPSR3

[Reagan]

Could you provide the drop command ?

[Former Member]

drop tablespace psapsr3 including contents and datafiles cascade constraints

[Reagan]

That is not brspace tablepsace drop command.

If you use BRTools you will have a drop command like this

brspace -c force -o process,time -u / -f tsdrop -t PSAPSR3

[Former Member]

Hello RB,

Thanks for your help... hope it works

regards,

Pavan