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.

What happens if the defined default tablespace of a partitioned segment no longer exists?

April 26, 2017Default defined exists happens longer partitioned segment tablespace

0

Posted

What happens if the defined default tablespace of a partitioned segment no longer exists?

1 Answer

0

Posted

If, during a reorganization, you delete a tablespace, for example, which is defined as DEF_TABLESPACE_NAME in DBA_PART_TABLES or DBA_PART_INDEXES, the tablespace name is replaced by a placeholder such as _$deleted$7$0. If you now perform an ADD PARTITION, it leads to the following errors: ORA-00959: tablespace ‘_$deleted$8$0’ does not exist You can correct this by adjusting the tablespace name using MODIFY DEFAULT ATTRIBUTES as described above. BRSPACE performs this adjustment automatically during the reorganization.