Inclusion_4 (103.sql) - ORA-00955: name is already used by an existing object

ohdsi-studies / PioneerWatchfulWaiting

This study is part of the joint PIONEER - EHDEN - OHDSI studyathon in March 2021, and aims to advance understanding of clinical management and outcomes of watchful waiting in prostate cancer.

Apache License 2.0

7 stars 18 forks source link

Inclusion_4 (103.sql) - ORA-00955: name is already used by an existing object #62

Closed scossin closed 3 years ago

scossin commented 3 years ago

Peter reported this issue and I encountered it too: peter_103_issue

According to Bertrand:

Could it an easy fix that the second 4 should be changed to 5 and so on? (BTW, lines 483 and 533 in 103.sql).

keesvanbochove commented 3 years ago

This is a temporary table that should be dropped in the same script. Perhaps it is caused by an earlier script that was interrupted? For a new full run, you can DROP SCHEMA CASCADE (PostgreSQL syntax) and that should resolve this issue.