Skip to Content
0
Aug 04, 2016 at 10:29 AM

Oracle 12c IOTC Error

56 Views

Hi All,

Further to my other post which I have now resolved, I've run into another error :-

ORA-12089: cannot online redefine table "SAPSR3"."SCPRSVALS" with no primary key

ORA-06512: at "SAPSR3.IOTC", line 619

ORA-06512: at line 10

Processing the 10 largest tables

Processing table SAPSR3.SCPRSVALS

0:: Error_Stack...

0:: ORA-12089: cannot online redefine table "SAPSR3"."SCPRSVALS" with no primary key

0::

0:: Error_Backtrace...

0:: ORA-06512: at "SYS.DBMS_REDEFINITION", line 180

0:: ORA-06512: at "SYS.DBMS_REDEFINITION", line 3780

0:: ORA-06512: at "SAPSR3.IOTC", line 718

0::

0:: Fatal error - See preceding lines

0:: Error_Stack...

0:: ORA-12089: cannot online redefine table "SAPSR3"."SCPRSVALS" with no primary key

0::

0:: Error_Backtrace...

0:: ORA-06512: at "SAPSR3.IOTC", line 844

0:: ORA-06512: at "SAPSR3.IOTC", line 601

0::

0:: Fatal error - See preceding lines

Command I ran was iotc.convert (10,4)

I've check this table and it definitely has a primary key, so I am a little unsure of what it's complaining about.

But when viewing the definition using describe I see something different between 2 environments for the same table.

DEV

SQL> describe SCPRSVALS;

Name Null? Type

----------------------------------------- -------- ----------------------------

ID VARCHAR2(96)

VERSION VARCHAR2(3)

TABLENAME VARCHAR2(90)

RECNUMBER VARCHAR2(30)

FIELDNAME VARCHAR2(90)

FLAG VARCHAR2(9)

VALUE VARCHAR2(765)

UAT

SQL> describe SCPRSVALS;

Name Null? Type

----------------------------------------- -------- ----------------------------

ID NOT NULL VARCHAR2(96)

VERSION NOT NULL VARCHAR2(3)

TABLENAME NOT NULL VARCHAR2(90)

RECNUMBER NOT NULL VARCHAR2(30)

FIELDNAME NOT NULL VARCHAR2(90)

FLAG NOT NULL VARCHAR2(9)

VALUE NOT NULL VARCHAR2(765)

Suggestions?

Thansk

Craig