ASHFORD_CORE@atgdb1> show user USER is "ASHFORD_CORE" ASHFORD_CORE@atgdb1> sta create_hsww_sekeywords.sql Enter value for run_by: pcheung old 16: '&run_by' , new 16: 'pcheung' , Enter value for schema_name: ASHFORD_CORE old 17: '&schema_name', new 17: 'ASHFORD_CORE', Enter value for comments_executor: old 22: '&comments_executor' new 22: '' '' * ERROR at line 22: ORA-01400: cannot insert NULL into ("ASHFORD_UTILS"."SCRIPT_EXECUTION_HISTORY"."COMMENTS_EXECUTOR") Table created. ASHFORD_CORE@atgdb1> select distinct COMMENTS_EXECUTOR from script_execution_history; COMMENTS_EXECUTOR -------------------------------------------------------------------------------- ticket 1514769 1502344 ticket 1545064 ticket 1532293 ticket 1514835 ticket 1514835 6 rows selected. ASHFORD_CORE@atgdb1> sta create_hsww_sekeywords.sql Enter value for run_by: pcheung old 16: '&run_by' , new 16: 'pcheung' , Enter value for schema_name: ASHFORD_CORE old 17: '&schema_name', new 17: 'ASHFORD_CORE', Enter value for comments_executor: ticket 1545531 old 22: '&comments_executor' new 22: 'ticket 1545531' 1 row created. create table hsww_sekeywords ( * ERROR at line 1: ORA-00955: name is already used by an existing object ASHFORD_CORE@atgdb1> commit; Commit complete. ASHFORD_CORE@atgdb1> conn ashford_stg Connected. ASHFORD_STG@atgdb1> show user USER is "ASHFORD_STG" ASHFORD_STG@atgdb1> sta create_hsww_sekeywords.sql Enter value for run_by: pcheung old 16: '&run_by' , new 16: 'pcheung' , Enter value for schema_name: ASHFORD_STG old 17: '&schema_name', new 17: 'ASHFORD_STG', Enter value for comments_executor: ticket 1545531 old 22: '&comments_executor' new 22: 'ticket 1545531' 1 row created. Table created. ASHFORD_STG@atgdb1> commi;t SP2-0042: unknown command "commi;t" - rest of line ignored. ASHFORD_STG@atgdb1> commit; Commit complete. ASHFORD_STG@atgdb1> conn ASHFORD_PUB Connected. ASHFORD_PUB@atgdb1> SHOW USER USER is "ASHFORD_PUB" ASHFORD_PUB@atgdb1> sta create_hsww_sekeywords.sql Enter value for run_by: pcheung old 16: '&run_by' , new 16: 'pcheung' , Enter value for schema_name: ASHFORD_PUB old 17: '&schema_name', new 17: 'ASHFORD_PUB', Enter value for comments_executor: ticket 1545531 old 22: '&comments_executor' new 22: 'ticket 1545531' 1 row created. Table created. ASHFORD_PUB@atgdb1> commit; Commit complete. ASHFORD_PUB@atgdb1> conn ashford_core Connected. ASHFORD_CORE@atgdb1> show user USER is "ASHFORD_CORE" ASHFORD_CORE@atgdb1> sta insert_das_id_generator_facebook.sql Enter value for run_by: pcheung old 16: '&run_by' , new 16: 'pcheung' , Enter value for schema_name: ASHFORD_CORE old 17: '&schema_name', new 17: 'ASHFORD_CORE', Enter value for comments_executor: ticket 1545531 old 22: '&comments_executor' new 22: 'ticket 1545531' 1 row created. 1 row created. Commit complete. ASHFORD_CORE@atgdb1> conn ashford_stg Connected. ASHFORD_STG@atgdb1> show user USER is "ASHFORD_STG" ASHFORD_STG@atgdb1> conn ashford_core Connected. ASHFORD_CORE@atgdb1> show user USER is "ASHFORD_CORE" ASHFORD_CORE@atgdb1> sta create_facebookPage.sql Enter value for run_by: pcheung old 16: '&run_by' , new 16: 'pcheung' , Enter value for schema_name: ASHFORD_CORE old 17: '&schema_name', new 17: 'ASHFORD_CORE', Enter value for comments_executor: ticket 1545531 old 22: '&comments_executor' new 22: 'ticket 1545531' 1 row created. Table created. ASHFORD_CORE@atgdb1> conn ashford_stg Connected. ASHFORD_STG@atgdb1> show user USER is "ASHFORD_STG" ASHFORD_STG@atgdb1> sta create_facebookPage.sql Enter value for run_by: pcheung old 16: '&run_by' , new 16: 'pcheung' , Enter value for schema_name: ASHFORD_STG old 17: '&schema_name', new 17: 'ASHFORD_STG', Enter value for comments_executor: ticket 1545531 old 22: '&comments_executor' new 22: 'ticket 1545531' 1 row created. Table created. ASHFORD_STG@atgdb1> sta insert_das_id_generator_facebook.sql Enter value for run_by: pcheung old 16: '&run_by' , new 16: 'pcheung' , Enter value for schema_name: ASHFORD_STG old 17: '&schema_name', new 17: 'ASHFORD_STG', Enter value for comments_executor: ticket 1545531 old 22: '&comments_executor' new 22: 'ticket 1545531' 1 row created. 1 row created. Commit complete. ASHFORD_STG@atgdb1> conn ashford_pub Connected. ASHFORD_PUB@atgdb1> show user USER is "ASHFORD_PUB" ASHFORD_PUB@atgdb1> sta create_facebookPage.sql Enter value for run_by: pcheung old 16: '&run_by' , new 16: 'pcheung' , Enter value for schema_name: ASHFORD_PUB old 17: '&schema_name', new 17: 'ASHFORD_PUB', Enter value for comments_executor: ticket 1545531 old 22: '&comments_executor' new 22: 'ticket 1545531' 1 row created. Table created. ASHFORD_PUB@atgdb1> commit; Commit complete. ASHFORD_PUB@atgdb1> spool off