Re: ORA-01135 selecting from the view

From: Inessa Weiner <ikar_at_med.cornell.edu>
Date: Wed, 12 Jul 2006 21:32:53 -0400
Message-id: <5.1.0.14.2.20060712164240.037c1288@pop.med.cornell.edu>

It is TEMPORARY according to dba_tablespaces.contents.
Error was fixed by
creating new temp tablespace and revoking privileges on the "old" one.

Thanks for your help.





At 10:17 PM 7/12/2006 +0200, you wrote:

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

-- http://www.freelists.org/webpage/oracle-l Received on Wed Jul 12 2006 - 20:32:53 CDT