RE: ORA-03232

From: James Bullard <jbullard_at_onvia.com>
Date: Wed, 3 May 2000 14:34:52 -0700
Message-Id: <10486.104868@fatcity.com>

One easy way to find the tablespace number is v$tablespace.

James

-----Original Message-----
From: paquette stephane [mailto:stephane_paquette_at_yahoo.com] Sent: Wednesday, May 03, 2000 9:30 AM
To: Multiple recipients of list ORACLE-L Subject: ORA-03232

Hi all,

I had an ORA-03232 today, according to the doc, I try to specify a hash_multiblock_io_count value that is greater than the next extent of the tablespace . Also, the error message indicates, tablespace 14. Where do I translate a tablespace number to a tablespace name ?

If I increase hash_area_size to avoid going to disk , I do not have the problem. The
hash_multiblock_io_count is supposed to be query dependent so I did not set it up.

Oracle 8.1.5/Solaris 2.6

---

Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50

---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Wed May 03 2000 - 16:34:52 CDT