I am getting a
ORA-00959: tablespace 'TEMP' does not exist
when I try to run a query.
I checked the assigned default & temporary tablespace for the user and 'TEMP' is neither of them. In fact there is no tablespace called 'TEMP' in the database at all. Also I have not mentioned any tablespace name in the query.
Does anyone know what is causing this error ?
Any ideas greatly appreciated.