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