Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center