adds oracle link and partial