Re: ORA-01135 selecting from the view

Create new temporary tablespace (with tempfiles, you're on 8i), assign it to your users (alter user <username> temporary tablespace <new_temp>), drop the old one.

If you're NOT sure that the tablespace is temporary, don't drop it for now (check dba_tablespaces.contents column)!



Dimitre


--
http://www.freelists.org/webpage/oracle-l


Other related posts: