I have a table created in tablespace A with index in tablespace B. Can I drop just one of the two tablespaces and then rebuild that one alone?

0
Posted

I have a table created in tablespace A with index in tablespace B. Can I drop just one of the two tablespaces and then rebuild that one alone?

0

No. You cannot drop a tablespace without dropping all tablespaces that are associated with it. Example, in this specific case, you have to drop both index and data tablespace in one drop command. C.

Related Questions