Dear All,
two days ago, we created the following snapshot (see above) without any problems.
CREATE SNAPSHOT ksa_dba.sys_schnr_webksa_max_repl
STORAGE (
INITIAL 40k
NEXT 40k
PCTINCREASE 0)
TABLESPACE TS_SCH
NOLOGGING
BUILD IMMEDIATE
USING INDEX STORAGE(
INITIAL 40k
NEXT 40k
PCTINCREASE 0) TABLESPACE TS_IND1
REFRESH COMPLETE WITH ROWID ON DEMAND
AS
SELECT 0 lfd_mod_2,sp.sparte, NVL((mlfd),0) max_lfd
FROM repl_ksa.sys_sparte sp,
(SELECT sparte, MAX(MOD(schnr,100000)) mlfd
FROM repl_ksa.meld_sch
WHERE
anl >= TRUNC(SYSDATE,'YYYY')
AND MOD(schnr,2) = 0
GROUP BY sparte) sc
WHERE
sp.sparte < 10
AND sc.sparte (+) =sp.sparte
UNION
SELECT 1 lfd_mod_2,sp.sparte, NVL((mlfd),0) max_lfd
FROM repl_ksa.sys_sparte sp,
(SELECT sparte, MAX(MOD(schnr,100000)) mlfd
FROM repl_ksa.meld_sch
WHERE
anl >= TRUNC(SYSDATE,'YYYY')
AND MOD(schnr,2) = 1
GROUP BY sparte) sc
WHERE
sp.sparte < 10
AND sc.sparte (+) = sp.sparte
;
>From yesterday, we still in trouble. If we try to create it from a client with sql*plus,
we get an ORA-03113 (end-of-file on communication channel). On the server itself,
with sql*plus we get a core dump file.
In the trace file we get only the entry above:
Tue May 15 16:14:46 2001
Errors in file
/usr/local/oracle/8i/u01/app/oracle/admin/GLBL/udump/ora_9784.trc:
ORA-07445: exception encountered: core dump [11] [0] [] [] [] []
Has anybody ANY idea what happend to our instance ???
TIA
Andreas
-- --
Novedia AG, Hardenbergstraße 19
Andreas Teich, Dipl.-Math. Tel +49 30 311889-57
10623 Berlin-Charlottenburg Fax +49 30 311889-19
mailto:[EMAIL PROTECTED] http://novedia.de
-------
One OS to rule them all, One OS to find them,
One OS to bring them all and in the darkness bind them...
