<html> <br> It is <font face="Courier New, Courier">TEMPORARY</font><font face="Courier New, Courier" size=4> </font>according to dba_tablespaces.contents.<br> Error was fixed by<br> creating new temp tablespace and revoking privileges on the "old" one .<br><br> Thanks for your help.<br><br> <br><br> <br><br> At 10:17 PM 7/12/2006 +0200, you wrote:<br> <blockquote type=cite class=cite cite><blockquote type=cite class=cite cite >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.</blockquote><br> If you're NOT sure that the tablespace is temporary, don't drop it for now (check dba_tablespaces.contents column)!<br><br> <br> Dimitre <br> --<br> <a href="http://www.freelists.org/webpage/oracle-l" eudora="autourl">http://www .freelists.org/webpage/oracle-l</a><br> </blockquote></html>
