OLTP_USER@WNPDEV1> show user USER is "OLTP_USER" OLTP_USER@WNPDEV1> sta ./dbdeploy/002_CHANGELOG.sql 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. OLTP_USER@WNPDEV1> sta ./data/001_STATUS.sql Insert into STATUS (ID,NAME) values (1,'Active') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.STATUS_PK) violated Insert into STATUS (ID,NAME) values (8,'Cancelled') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.STATUS_PK) violated Insert into STATUS (ID,NAME) values (4,'Deleted') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.STATUS_PK) violated Insert into STATUS (ID,NAME) values (3,'Error') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.STATUS_PK) violated Insert into STATUS (ID,NAME) values (2,'InActive') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.STATUS_PK) violated Insert into STATUS (ID,NAME) values (5,'Marked for Deletion') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.STATUS_PK) violated Insert into STATUS (ID,NAME) values (6,'Pending') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.STATUS_PK) violated Insert into STATUS (ID,NAME) values (7,'Sent') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.STATUS_PK) violated OLTP_USER@WNPDEV1> sta ./data/002_COMPANY.sql 1 row created. 1 row created. 1 row created. OLTP_USER@WNPDEV1> sta ./data/003_AUTHORIZATION.sql 1 row created. 1 row created. 1 row created. OLTP_USER@WNPDEV1> sta ./data/004_PRODUCT.sql 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. OLTP_USER@WNPDEV1> sta ./data/005_AUTHORIZED_PRODUCT.sql 1 row created. 1 row created. 1 row created. 1 row created. OLTP_USER@WNPDEV1> sta ./data/006_ERROR.sql Insert into ERROR (ID,NAME) values ('ER0001','The value is null') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.ERROR_PK) violated Insert into ERROR (ID,NAME) values ('ER0002','The value is not in a valid format') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.ERROR_PK) violated Insert into ERROR (ID,NAME) values ('ER0003','The value is out of expected range') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.ERROR_PK) violated Insert into ERROR (ID,NAME) values ('ER0004','The value is not valid') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.ERROR_PK) violated OLTP_USER@WNPDEV1> sta ./data/007_EVENT.sql Insert into EVENT (ID,NAME) values (10,'Eval 1 expired') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (8,'User Registered') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (9,'User Enrolled') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (11,'Eval 2 expired') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (12,'Eval 3 expired') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (13,'Eval 2 available') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (14,'Eval 3 available') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (4,'Refill Reminder Created') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (5,'Refill Reminder Queued') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (1,'Baseline Started') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (2,'Baseline Completed') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (6,'Plan Tailored') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated Insert into EVENT (ID,NAME) values (7,'Eval 1 available') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.EVENT_PK) violated OLTP_USER@WNPDEV1> sta ./data/008_GLOBAL_APPLICATION.sql 1 row created. 1 row created. 1 row created. 1 row created. OLTP_USER@WNPDEV1> sta ./data/009_DATA_SOURCE.sql Insert into DATA_SOURCE (ID,NAME) values (3,'Eligibility') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.DATA_SOURCE_PK) violated Insert into DATA_SOURCE (ID,NAME) values (1,'User Entered') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.DATA_SOURCE_PK) violated 1 row created. OLTP_USER@WNPDEV1> sta ./data/010_GLOBAL_USER.sql 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. OLTP_USER@WNPDEV1> sta ./data/011_GLOBAL_EXTERNAL_USER_LOOKUP.sql 1 row created. 1 row created. 1 row created. OLTP_USER@WNPDEV1> sta ./data/012_LOCALE.sql 1 row created. OLTP_USER@WNPDEV1> sta ./data/013_WNP_USER.sql 1 row created. 1 row created. 1 row created. OLTP_USER@WNPDEV1> sta ./data/014_PRODUCT_ENROLLMENT.sql Insert into PRODUCT_ENROLLMENT (ID,ENROLLMENT_DT,WNP_USER_ID,PRODUCT_VERSION_ID,ENROLLMENT_METHOD,STATUS_ID,LEGACY_ID) values (1,to_timestamp('19-JAN-10','DD-MON-RR HH.MI.SS.FF AM'),1,1,'WEB',1,null) * ERROR at line 1: ORA-02291: integrity constraint (OLTP_USER.PRODUCT_ENROLLMENT_R1) violated - parent key not found Insert into PRODUCT_ENROLLMENT (ID,ENROLLMENT_DT,WNP_USER_ID,PRODUCT_VERSION_ID,ENROLLMENT_METHOD,STATUS_ID,LEGACY_ID) values (2,to_timestamp('10-FEB-11','DD-MON-RR HH.MI.SS.FF AM'),1,3,'WEB',1,null) * ERROR at line 1: ORA-02291: integrity constraint (OLTP_USER.PRODUCT_ENROLLMENT_R1) violated - parent key not found Insert into PRODUCT_ENROLLMENT (ID,ENROLLMENT_DT,WNP_USER_ID,PRODUCT_VERSION_ID,ENROLLMENT_METHOD,STATUS_ID,LEGACY_ID) values (201,to_timestamp('10-FEB-10','DD-MON-RR HH.MI.SS.FF AM'),10100,3,'WEB',1,null) * ERROR at line 1: ORA-02291: integrity constraint (OLTP_USER.PRODUCT_ENROLLMENT_R1) violated - parent key not found OLTP_USER@WNPDEV1> sta ./data/015_PRODUCT_VERSION.sql 1 row created. 1 row created. 1 row created. 1 row created. Insert into PRODUCT_VERSION (ID,VERSION_NUMBER,PRODUCT_ID,LEGACY_CODE,LEGACY_ID) values (622,'1111',15754,null,null) * ERROR at line 1: ORA-02291: integrity constraint (OLTP_USER.PRODUCT_VERSION_R1) violated - parent key not found 1 row created. 1 row created. 1 row created. OLTP_USER@WNPDEV1> sta ./data/016_SBS_ACTIVITY.sql Insert into SBS_ACTIVITY (ID,NAME) values (2,'running') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.SBS_ACTIVITY_PK) violated Insert into SBS_ACTIVITY (ID,NAME) values (3,'swimming') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.SBS_ACTIVITY_PK) violated Insert into SBS_ACTIVITY (ID,NAME) values (4,'biking') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.SBS_ACTIVITY_PK) violated Insert into SBS_ACTIVITY (ID,NAME) values (5,'other') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.SBS_ACTIVITY_PK) violated Insert into SBS_ACTIVITY (ID,NAME) values (1,'walking') * ERROR at line 1: ORA-00001: unique constraint (OLTP_USER.SBS_ACTIVITY_PK) violated OLTP_USER@WNPDEV1> commit; Commit complete. OLTP_USER@WNPDEV1> spool off