RE: ORA-03232

You could try

select distinct tablespace_name, tablespace_id from SYS_DBA_SEGS

George

> -----Original Message-----
> From: "paquette stephane" <stephane_paquette_at_yahoo.com>
> [mailto:stephane_paquette_at_yahoo.com]
> Sent: Wednesday, May 03, 2000 5:30 PM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> 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 - 12:00:19 CDT