ORA-00959 tablespace TEMP2 does not exist when query
626620Oct 27 2009 — edited Oct 29 2009I used has two temporary tablespaces TEMP and TEMP2. TEMP is the default temporary tablespace, and TEMP2 is notused. Recently I dropped TEMP2. Then I got the ORA-00959 when I do
select * from V_PERSON; --get ORA-00959
select * from D_PERSON; -- OK
Here V_PERSON is a simple view based on table D_PERSON. I recreated the view. but still have the problem.