Spotlight user wizard has encountered an error ... (93384)

Spotlight user wizard has encountered an error
An Error was reported
"SoOTables" in connection "nnnnn"
The Error is:
ORA-00959 table space '_$deleted$000" does not exist
ORA-06512 at line 12
In table SooTables
 

You can drop/cascade your Spotlight user and recreate.

The most likely reason this error is coming up is that you have moved the tables from the original tablespace they were created on to another, dropped the original tablespace and not updated the user’s default tablespace to reflect where these tables now are.

For example the following will turn up what the issue is for my user ‘PP90’ if tablespace_name is not equal to default_tablespace –

select t.owner,t.table_name,t.tablespace_name from all_tables t where owner like 'PP90';

select d.default_tablespace from dba_users d where username like 'PP90';