X-FeedAbuse: http://nntpfeed.proxad.net/abuse.pl feeded by 88.191.116.97 Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!212.27.60.9.MISMATCH!proxad.net!feeder2-2.proxad.net!nntpfeed.proxad.net!dedibox.gegeweb.org!gegeweb.eu!gegeweb.org!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: Temp tablespace full Date: Mon, 11 Nov 2013 00:15:04 +0000 (UTC) Organization: A noiseless patient Spider Lines: 12 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Injection-Date: Mon, 11 Nov 2013 00:15:04 +0000 (UTC) Injection-Info: mx05.eternal-september.org; posting-host="e4f8def8fb90dfd954091bdd9211c78d"; logging-data="27226"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+gajjEKfRU0f7vwDMwvb/2" User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) Cancel-Lock: sha1:wWzlJ2J4PkUFTD/i38JOYYnLo1k= Xref: news.cambrium.nl On Sun, 10 Nov 2013 15:04:45 -0800, dbaonline99 wrote: > am getting the error Temp table-space full Why don't you look into V$SORT_USAGE and fix it? -- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com