Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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?

April 26, 2017drop index rebuild Table tablespace tablespaces

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?

1 Answer

0

Posted

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.