OLTP_USER@WNPDEV1> show user USER is "OLTP_USER" OLTP_USER@WNPDEV1> sta ./changes2/059_add_indexes_on_fk_columns.sql Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. OLTP_USER@WNPDEV1> sta ./changes2/060_communicationcenter_tables.sql Table created. 1 row created. Grant succeeded. Grant succeeded. Sequence created. Table created. Trigger created. Trigger created. Grant succeeded. Grant succeeded. Table created. Grant succeeded. Grant succeeded. Trigger created. Comment created. Comment created. Comment created. Sequence created. SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored. (MESSAGE_TYPE IN ('EMAIL', 'SMS', 'MMS', 'TELEPHONE', 'FAX', 'POSTALMAIL')), * ERROR at line 1: ORA-00928: missing SELECT keyword ON MESSAGE_LOG * ERROR at line 3: ORA-00942: table or view does not exist ON MESSAGE_LOG * ERROR at line 3: ORA-00942: table or view does not exist GRANT INSERT, SELECT, UPDATE ON MESSAGE_LOG TO USERS_FULL * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON MESSAGE_LOG TO USERS_VIEW * ERROR at line 1: ORA-00942: table or view does not exist Table created. Trigger created. Grant succeeded. Grant succeeded. Sequence created. CONSTRAINT MESSAGE_DATA_LOG_R1 FOREIGN KEY (MESSAGE_LOG_ID) REFERENCES MESSAGE_LOG (ID), * ERROR at line 11: ORA-00942: table or view does not exist ON MESSAGE_DATA_LOG * ERROR at line 3: ORA-00942: table or view does not exist ON MESSAGE_DATA_LOG * ERROR at line 3: ORA-00942: table or view does not exist GRANT INSERT, SELECT, UPDATE ON MESSAGE_DATA_LOG TO USERS_FULL * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON MESSAGE_DATA_LOG TO USERS_VIEW * ERROR at line 1: ORA-00942: table or view does not exist CREATE INDEX MESSAGE_DATA_LOG_IF ON MESSAGE_DATA_LOG(MESSAGE_DATA_ID) * ERROR at line 1: ORA-00942: table or view does not exist CREATE INDEX MESSAGE_LOG_IF ON MESSAGE_LOG(WNP_USER_ID) * ERROR at line 1: ORA-00942: table or view does not exist OLTP_USER@WNPDEV1> sta 060_communicationcenter_tables_fix.sql SP2-0310: unable to open file "060_communicationcenter_tables_fix.sql" OLTP_USER@WNPDEV1> sta ./changes2/060_communicationcenter_tables_fix.sql Table created. Trigger created. Trigger created. Grant succeeded. Grant succeeded. CREATE TABLE MESSAGE_DATA * ERROR at line 1: ORA-00955: name is already used by an existing object Trigger created. Grant succeeded. Grant succeeded. CREATE SEQUENCE MESSAGE_DATA_LOG_S * ERROR at line 1: ORA-00955: name is already used by an existing object Table created. Trigger created. Trigger created. Grant succeeded. Grant succeeded. Index created. Index created. OLTP_USER@WNPDEV1> sta ./changes2/061_std_eligibility_tables.sql Table created. Grant succeeded. Grant succeeded. Trigger created. Sequence created. Trigger created. Table created. Grant succeeded. Grant succeeded. Trigger created. Sequence created. Warning: Trigger created with compilation errors. Table altered. OLTP_USER@WNPDEV1> sta ./changes2/062_std_eligibility_trigger.sql Trigger created. Table altered. OLTP_USER@WNPDEV1> sta ./changes2/063_add_goal_date_to_goal_physical_activity.sql Table altered. OLTP_USER@WNPDEV1> sta ./changes2/064_insert_into_error_table.sql Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. Table altered. 1 row created. 1 row created. 1 row created. Table altered. OLTP_USER@WNPDEV1> sta ./changes2/065_insert_into_error_table.sql 1 row created. OLTP_USER@WNPDEV1> sta ./changes2/066_remove_unique_constraint_on_goal.sql Table altered. OLTP_USER@WNPDEV1> sta ./changes2/067_insert_data_for_eligibility.sql 1 row created. 1 row created. Commit complete. OLTP_USER@WNPDEV1> sta ./changes2/068_create_user_data_history_set_table.sql Table created. Table altered. OLTP_USER@WNPDEV1> sta ./dbdeploy/001_createSchemaVersionTable.ora.sql CREATE TABLE changelog ( * ERROR at line 1: ORA-00955: name is already used by an existing object ALTER TABLE changelog ADD CONSTRAINT Pkchangelog PRIMARY KEY (change_number) * ERROR at line 1: ORA-02260: table can have only one primary key OLTP_USER@WNPDEV1> spool off