Create Snapshot failed

From: Andreas Teich <teich_at_novedia.de>
Date: Wed, 16 May 2001 06:18:16 -0700
Message-ID: <F001.00304B87.20010516055039@fatcity.com>

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:teich@novedia.de 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...

Received on Wed May 16 2001 - 08:18:16 CDT

Create Snapshot failed - why ?