My Oracle Support Banner

Unable To Drop DB Account From LSH UI (Doc ID 3059413.1)

Last updated on NOVEMBER 18, 2024

Applies to:

Oracle Life Sciences Data Hub - Version 3.1.1.5 and later
Information in this document applies to any platform.

Symptoms

On Oracle Life Sciences Data Hub (LSH) when attempting to drop a Database user account from UI, the following error occurs:

ERROR(S)
=========

ORA-01940: cannot drop a user that is currently connected in Package cdr_df_table.deleteTableConsCols Procedure cdr_table_cons_cols_m.DELETEROW

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.