Re: ORA-01135 selecting from the view

> It is temp Temp tablespace.
> Can drop/recreate temp tablespace easily?
>
> It is a production system.

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.

Still curious to see the segments (name/type) in the old one :)

Regards
Dimitre

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