Re: ORA-01135 selecting from the view

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: "Inessa Weiner" <ikar@xxxxxxxxxxxxxxx>
  • Date: Wed, 12 Jul 2006 22:17:22 +0200

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)!



Other related posts: