X-Received: by 10.42.66.147 with SMTP id p19mr7540855ici.12.1384124802960; Sun, 10 Nov 2013 15:06:42 -0800 (PST) X-Received: by 10.183.1.40 with SMTP id bd8mr31628obd.11.1384124802821; Sun, 10 Nov 2013 15:06:42 -0800 (PST) Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!209.197.12.242.MISMATCH!nx01.iad01.newshosting.com!newshosting.com!69.16.185.111.MISMATCH!peer01.iad.highwinds-media.com!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!i2no19538212qav.0!news-out.google.com!9ni19737qaf.0!nntp.google.com!o2no28509643qas.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Sun, 10 Nov 2013 15:06:42 -0800 (PST) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=76.185.132.163; posting-account=EZnBRwoAAACoVatc_dcLXiTV2692t6O1 NNTP-Posting-Host: 76.185.132.163 References: User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: Temp tablespace full From: kedar@techsql.net Injection-Date: Sun, 10 Nov 2013 23:06:42 +0000 Content-Type: text/plain; charset=ISO-8859-1 X-Received-Bytes: 1750 X-Received-Body-CRC: 703104630 Xref: news.cambrium.nl On Sunday, November 10, 2013 5:04:45 PM UTC-6, dbaon...@gmail.com wrote: > am getting the error Temp table-space full if its something like below ORA-1652: unable to extend temp segment by %s in tablespace %s Cause: Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated. Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated. You can also read below one for more info. http://www.techsql.com/ora-01652.htm