Default Tablespace Showing the OLD Tablespace Name .
Hello Team,
I am in a situation where I performed a reorg Activity by moving all the Object of OLD table Space in a New tablespace .Well I dropped the OLD tablespace after confirming that all the Objects are moved to new tablespace .
But now we have couple of Partition tables where now the developers are inserting new data and they are getting error
ORA-00959: tablespace 'USERS3' does not exist
I checked in the view DBA_PART_TABLES and DBA_PART_INDEXES all default tablespace column is pointing to this Old tablespace which is no more existing
Below are steps are did before dropping the OLD tablespace