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

Home -> Community -> Usenet -> c.d.o.server -> Ora-600 on snapshot (mview)

Ora-600 on snapshot (mview)

From: Yavor Ivanov <yavor_ivanov_at_stemo.bg>
Date: 18 Jul 2002 05:50:53 -0700
Message-ID: <9588a8de.0207180450.47730ca@posting.google.com>


I'm in deep trouble. I have an ASAP task to populate an snapshot on 8 sites. As always, I've created table, snapshot log and replication object on a master site. I've created the (updateable!) snapshot on snapshot sites. But with one of the sites the connection was lost during snapshot creation (with OEM 9i). Since then I'm not able to select, alter, drop, create, analyze or anything that snapshot. I'm not able to move it's table or rebuild it's Primary Key Index. The error I always get is "ORA-00600: internal error code, arguments: [ktsircinfo_num1], [0], [1],[255695], [], [], [], []".

    It is Oracle 9i R1/Windows 2000 server both master and snapshot sites.

    Please help me to drop the wrong object or normalize it. And it's urgent, of course.

    Rgds,
    Yavor Received on Thu Jul 18 2002 - 07:50:53 CDT

Original text of this message

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