Monday, 13 October 2014

ORA-00600: internal error code, arguments: [qespcNpSC:objnotfound], in data mover

ORA-600 that's scary stuff, As its a Oracle internal error, so always recommended to raise a ticket.

I did something else due to shortage of time:--

In my environments scenario this error came when I tried to run the database setup from data mover and it failed at 






As i was under time pressure,instead of following up with Oracle I did the following steps.

As it failed while inserting into the PSDBOWNER table , there must be something fishy with the way PSDBOWNER table was created, So I created the DDL of PSDBOWNER table


SQL> select dbms_metadata.get_ddl('TABLE','PSDBOWNER','PS') from dual;

The output was :

  CREATE TABLE "PS"."PSDBOWNER"
   (    "DBNAME" VARCHAR2(8) NOT NULL ENABLE,
        "OWNERID" VARCHAR2(8) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  TABLESPACE "PSDEFAULT"
Then I dropped the table PSDBOWNER, and recreated the table using the above output

I reran the insert, and ORA-600 vanished.

Respond for any doubts, and keep experimenting!!


No comments:

Post a Comment