SYSTEM@myriad1> alter session set current_schema=MYRIAD; Session altered. SYSTEM@myriad1> desc mid_paysol_limits Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER(18) S_DATECREATED NOT NULL DATE S_CREATOR NOT NULL NUMBER(5) S_DATEMODIFIED DATE S_MODIFIER NUMBER(5) MID NOT NULL NUMBER(18) PAYSOL_ID NOT NULL NUMBER(18) CURRENCY_ISO NOT NULL VARCHAR2(3) MIN_DEPOSIT NUMBER(20) MIN_WITHDRAW NUMBER(20) MAX_DEPOSIT NUMBER(20) MAX_WITHDRAW NUMBER(20) LIMIT_ACTIVEYN NOT NULL NUMBER(1) DCC_ACTIVEYN NOT NULL NUMBER(1) DCC_CURRENCY_ISO VARCHAR2(3) DCC_DEPOSIT_MIN_VALUE NUMBER(20) DCC_DEPOSIT_MAX_VALUE NUMBER(20) DCC_WITHDRAW_MIN_VALUE NUMBER(20) DCC_WITHDRAW_MAX_VALUE NUMBER(20) COUNTRY_ALPHA2 VARCHAR2(2) SYSTEM@myriad1> sta ORDINAL_POS_MID_PAYSOL_LIMITS.txt alter table mid_paysol_limits add column ordinal_pos number(2) * ERROR at line 1: ORA-00904: : invalid identifier update mid_paysol_limits set ordinal_pos = 1 where currency_iso = 'GBP' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 2 where currency_iso = 'EUR' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 3 where currency_iso = 'USD' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 4 where currency_iso = 'CNY' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 5 where currency_iso = 'RMB' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 6 where currency_iso = 'HKD' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 7 where currency_iso = 'JPY' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 8 where currency_iso = 'CHF' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 9 where currency_iso = 'NOK' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 10 where currency_iso = 'SEK' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 11 where currency_iso = 'NZD' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 12 where currency_iso = 'DKK' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 13 where currency_iso = 'RON' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 14 where currency_iso = 'TRY' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 15 where currency_iso = 'CAD' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 16 where currency_iso = 'ZAR' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 17 where currency_iso = 'AUD' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 18 where currency_iso = 'ARS' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 19 where currency_iso = 'ILS' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 20 where currency_iso = 'THB' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 21 where currency_iso = 'KRW' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 22 where currency_iso = 'HUF' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 23 where currency_iso = 'MYR' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 24 where currency_iso = 'TWD' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier update mid_paysol_limits set ordinal_pos = 25 where currency_iso = 'SGD' * ERROR at line 1: ORA-00904: "ORDINAL_POS": invalid identifier SYSTEM@myriad1> SYSTEM@myriad1> host SYSTEM@myriad1> sta ORDINAL_POS_MID_PAYSOL_LIMITS.txt.fix Table altered. 83 rows updated. 59 rows updated. 79 rows updated. 15 rows updated. 3 rows updated. 45 rows updated. 45 rows updated. 47 rows updated. 32 rows updated. 32 rows updated. 9 rows updated. 32 rows updated. 42 rows updated. 4 rows updated. 24 rows updated. 23 rows updated. 68 rows updated. 9 rows updated. 6 rows updated. 11 rows updated. 8 rows updated. 1 row updated. 1 row updated. 44 rows updated. 68 rows updated. SYSTEM@myriad1> spool off