Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Ora-600 on snapshot (mview)
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