Is There A Primary Key For The ESM_IMPORT_DATA Table? (Doc ID 2593154.1)

Last updated on JULY 13, 2023

Applies to:

Goal

I am attempting to identify a primary key when looking at data in ESM_OWNER.ESM_IMPORT_DATA

The table does not have a primary key assigned.

The table description indicates the combination of 4 columns should make the primary key (REPORT_ID, FIELD_ID, UNIQUE_SEQ_NUM, MULTI_ROW_ID1)
However those 4 column do not uniquely identify a row.

Solution

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