select count(*) from (select * from member order by member_level)
*
ERROR at line 1:
ORA-01652 (See ORA-01652.ora-code.com): unable to extend temp segment by 128 in tablespace FCPTEST
################
sqlcode = 1652
you can set event 1652
##########################
ALTER SESSION SET EVENTS '1652 trace name errorstack level 1 ';
or
alter system set events '1652 trace name errorstack level 1 ';
alter system set events '1652 trace name errorstack off ';
then generate the trace file
[oracle@(protected) udump]$ more ocndev_ora_15452.trc
/opt/oracle/admin/ocn/udump/ocndev_ora_15452.trc
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
JServer Release 9.2.0.3.0 - Production
ORACLE_HOME = /opt/oracle/products/9.2.0
System name: Linux
Node name: oradev
Release: 2.4.9-e.3
Version: #1 Fri May 3 17:02:43 EDT 2002
Machine: i686
Instance name: ocndev
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 15452, image: oracle@(protected) (TNS V1-V3)
*** SESSION ID:(85.639) 2004-08-24 17:50:19.030
*** 2004-08-24 17:50:19.030
ksedmp: internal or fatal error
ORA-01652 (See ORA-01652.ora-code.com): unable to extend temp segment by 128 in tablespace FCPTEST
Current SQL statement for this session:
select count(*) from (select * from alibaba.member order by member_level)
-- -- Call Stack Trace -- --
calling call entry argument values in hex
location type point (? means dubious value)
-- ---- ---- ---- -- -- ----- -- ---- ---- ---- -- -- ---- ---- ---- ---- -----
ksedmp()+269 call ksedst()+0 0 ? 0 ? 0 ? 0 ? 71417550 ?
70ECF9B8 ?
ksddoa()+446 call ksedmp()+0 1 ? AA703A8 ? 40622470 ?
674 ? 1 ? 406224D4 ?
ksdpcg()+521 call ksddoa()+0 40622470 ? AA703A8 ?
ksdpec()+220 call ksdpcg()+0 674 ? BFFE8D88 ? 1 ?
ksfpec()+133 call ksdpec()+0 674 ? 674 ? AA6D304 ?
Best regards
msn: biti_rainy@(protected)
a dba from alibaba(china)
---- from the mail-- --
>Is there an Oracle event that can be set, to capture the details of the
>database session 's errors in a trace file ? Use of Oracle event 10046
>provides only a simple indication that an error was raised, but does not
>provide details. For example:
>
> EXEC
>#1:c=10000,e=10498,p=0,cr=10,cu=9,mis=0,r=0,dep=0,og=4,tim=1526794508053
> ERROR #1:err=1 tim=156343757
>
>I would like to capture the error number (e.g. ORA-12345 (See ORA-12345.ora-code.com)) and pertinent
>text if possible. I do not require the entire error stack, simply the
>error as returned to a client application. Can anyone point me to details
>on an event like this? I am using Oracle 9.2 and 10.1 under Solaris.
>
>Kind regards,
>
>Andy Zitelli,
>Raytheon, Fullerton, CA
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>.
