ORA-00904: : INVALID IDENTIFIER DURING UPGRADE TO 18.3 WITH PARALLEL_DEGREE_LIMIT SET TO IO (Doc ID 2553620.1)

07:13:47 SQL> DECLARE 
07:13:47   2     col_type number; 
07:13:47   3  BEGIN 
07:13:47   4     -- update only if the session_key column is varchar2 
07:13:47   5     SELECT c.type# INTO col_type 
07:13:47   6     FROM col$ c, obj$ o, user$ u 
07:13:47   7     WHERE u.name = 'SYS' 
07:13:47   8       and u.user# = o.owner# 
07:13:47   9       and o.name = 'REG$' 
07:13:47  10       and o.type#=2 
07:13:47  11       and o.obj#=c.obj# 
07:13:47  12       and c.name = 'SESSION_KEY'; 
07:13:47  13     IF col_type=1 THEN   -- 12.1 column type was VARCHAR2, so 
change to RAW 
07:13:47  14       EXECUTE IMMEDIATE 
07:13:47  15         'ALTER TABLE reg$ ADD (temp RAW(1024))'; 
07:13:47  16       EXECUTE IMMEDIATE 
07:13:47  17          'UPDATE reg$ SET TEMP = 
utl_raw.cast_to_raw(session_key)'; 
07:13:47  18       EXECUTE IMMEDIATE 
07:13:47  19          'UPDATE reg$ SET session_key = NULL'; 
07:13:47  20       COMMIT; 
07:13:47  21       EXECUTE IMMEDIATE 
07:13:47  22          'ALTER TABLE reg$ MODIFY session_key RAW(1024)'; 
07:13:47  23       EXECUTE IMMEDIATE 
07:13:47  24          'UPDATE reg$ SET session_key = temp'; 
07:13:47  25       COMMIT; 
07:13:47  26       EXECUTE IMMEDIATE 
07:13:47  27          'ALTER TABLE reg$ DROP COLUMN temp'; 
07:13:47  28     END IF; 
07:13:47  29  END; 
07:13:47  30  /DECLARE 
* 
ERROR at line 1: 
ORA-00904: : invalid identifier 
ORA-06512: at line 21 

 

07:14:00 SQL> alter table job$ modify (cur_ses_label RAW(255), 
07:14:00   2                           CLEARANCE_HI RAW(255), 
07:14:00   3                           CLEARANCE_LO RAW(255)); 
alter table job$ modify (cur_ses_label RAW(255), 
* 
ERROR at line 1: 
ORA-00904: : invalid identifier