Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Create Snapshot failed - why ?

Create Snapshot failed - why ?

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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US