This discussion is archived
1 2 Previous Next 15 Replies Latest reply: May 3, 2013 4:30 PM by sb92075 RSS

ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated

993159 Newbie
Currently Being Moderated
Hi,

I m hit with a ORA-00001: unique constraint (STSSYS.SYS_C0038626) violation.

Below is the query trying to insert data into table sts_allmo. Can someone let me know how to find out the duplicate records from combining below query with table sts_allmo ?
SQL> INSERT INTO sts_allmo
  2  SELECT port_id,
  3                     'HBA Port',
  4                     to_char(x.port_number),
  5                     x.adport_alias,
  6                     hwcontainer.hwcontainerid,
  7                     'Host',
  8                     hwcontainer.hwcontainerserialnumber,
  9                      DECODE (hwcontainer.aliasname,
 10                     NULL, hwcontainer.hwcontainerserialnumber,
 11                     hwcontainer.aliasname
 12                             ),
 13                     hwcontainer.vendorname
 14                FROM  hwcontainer,host,sts_host_hba x
 15                WHERE host.physicalserverid = hwcontainer.hwcontainerid
 16                AND   host.hostid = x.host_id;
INSERT INTO sts_allmo
*
ERROR at line 1:
ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated


SQL> select table_name, column_name
  2  from DBA_cons_columns
  3  where owner='STSSYS'
  4  and constraint_name='SYS_C0038626'
  5  order by position;

_TABLE_NAME_                  _COLUMN_NAME_

STS_ALLMO                          MO_ID


SQL> desc hwcontainer
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ---------------------
 HWCONTAINERID                                         NOT NULL NUMBER(38)
 CONTAINERTYPE                                                  VARCHAR2(64)
 HWCONTAINERSERIALNUMBER                               NOT NULL VARCHAR2(255)
 STORAGESYSTEMID                                                NUMBER(38)
 PRODUCT                                                        VARCHAR2(64)
 HARDWAREREVISION                                               VARCHAR2(257)
 MODEL                                                          VARCHAR2(128)
 SOFTWAREREVISION                                               VARCHAR2(257)
 FIRMWAREREVISION                                               VARCHAR2(257)
 VENDORCODE                                                     VARCHAR2(128)
 VENDORNAME                                                     VARCHAR2(64)
 MODELDESCRIPTION                                               VARCHAR2(64)
 ALIASNAME                                                      VARCHAR2(128)
 GENERICTYPE                                                    VARCHAR2(32)
 SOURCEID                                                       NUMBER(38)
 STATE                                                          NUMBER(38)
 LASTUPDATETIMELCL                                              DATE
 TLLOCKNUM                                                      NUMBER(38)
 ACK                                                            CHAR(1)
 LASTDISCOVERYTIME                                              DATE
 DATASOURCETYPEID                                               NUMBER
 VIRTUALSTORAGEID                                               NUMBER(38)
 UNIFIEDSTORAGEID                                               NUMBER(38)
 ISPARTOFUNIFIEDSTORAGE                                         CHAR(1)

SQL> DESC HOST
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ---------------------
 PHYSICALSERVERID                                      NOT NULL NUMBER(38)
 HOSTNAME                                              NOT NULL VARCHAR2(255)
 HOSTCLUSTERID                                                  NUMBER(38)
 HOSTID                                                NOT NULL NUMBER(38)
 ESXSERVERID                                                    NUMBER(38)
 OPSYSID                                                        NUMBER(38)
 DESCRIPTION                                                    VARCHAR2(255)
 NODENAME                                                       VARCHAR2(128)
 GMTOFFSET                                                      NUMBER(38)
 DOMAINNAME                                                     VARCHAR2(255)
 ALIASNAME                                                      VARCHAR2(255)
 REALHOSTNAME                                                   VARCHAR2(255)
 SYMAPIVERSION                                                  VARCHAR2(128)
 USEDST                                                         CHAR(1)
 CONFIGUREDMEMORY                                               NUMBER(38)
 PRIIPADDRESS                                                   VARCHAR2(64)
 SECIPADDRESS                                                   VARCHAR2(64)
 VENDOR                                                         VARCHAR2(64)
 ACTIVITY                                                       NUMBER(38)
 INSTALLEDMEMORY                                                NUMBER(38)
 AVAILABLEMEMORY                                                NUMBER(38)
 CPU                                                            NUMBER(38)
 SERIALNUMBER                                                   VARCHAR2(32)
 GENERICTYPE                                                    VARCHAR2(32)
 STATE                                                          NUMBER(38)
 SOURCEID                                                       NUMBER(38)
 LASTUPDATETIMELCL                                              DATE
 TLLOCKNUM                                                      NUMBER(38)
 HOSTTYPE                                                       VARCHAR2(32)
 ACK                                                            CHAR(1)
 ENTITYTYPECODE                                                 VARCHAR2(64)
 HOSTDISPLAYNAME                                                VARCHAR2(255)
 LASTDISCOVERYTIME                                              DATE
 VMGUESTDISPLAYNAME                                             VARCHAR2(255)
 ISFULLYDISCOVERED                                              CHAR(1)
 VMGUESTSTATE                                                   VARCHAR2(64)
 VMTOOLSTATE                                                    VARCHAR2(64)
 VMSTATEDESCRIPTION                                             VARCHAR2(512)
 UUID                                                           VARCHAR2(512)
 DATASOURCETYPEID                                               NUMBER

SQL> DESC STS_HOST_HBA
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ---------------------
 AD_ID                                                 NOT NULL NUMBER(38)
 AD_NAME                                                        VARCHAR2(257)
 ADAPTER_NUMBER                                                 NUMBER
 HOST_ID                                               NOT NULL NUMBER(38)
 HOST_NAME                                                      VARCHAR2(255)
 HOST_ALIAS                                                     VARCHAR2(255)
 FIBREAD_NODEWWN                                                VARCHAR2(64)
 AD_PORTCOUNT                                                   NUMBER(38)
 AD_VENDOR                                                      VARCHAR2(257)
 AD_REVISION                                                    VARCHAR2(257)
 AD_MODEL                                                       VARCHAR2(257)
 PORT_ID                                               NOT NULL NUMBER(38)
 PORT_NUMBER                                                    NUMBER
 ADPORT_ALIAS                                                   VARCHAR2(386)
 PORT_WWN                                                       VARCHAR2(64)
 PORT_WWNNICKNAME                                               VARCHAR2(256)
 ISCSI_NAME                                                     VARCHAR2(256)
 AD_DRIVER_REV                                                  VARCHAR2(257)
 HOSTHBACUSTOMFIELD1                                            VARCHAR2(2048)
 HOSTHBACUSTOMFIELD2                                            VARCHAR2(2048)
 HOSTHBACUSTOMFIELD3                                            VARCHAR2(2048)
 HOSTHBACUSTOMFIELD4                                            VARCHAR2(2048)
 HOSTHBACUSTOMFIELD5                                            VARCHAR2(2048)
 HOSTHBACUSTOMFIELD6                                            VARCHAR2(2048)
 HOSTHBACUSTOMFIELD7                                            VARCHAR2(2048)
 HOSTHBACUSTOMFIELD8                                            VARCHAR2(2048)
 HOSTHBACUSTOMFIELD9                                            VARCHAR2(2048)
 HOSTHBACUSTOMFIELD10                                           VARCHAR2(2048)

SQL>
Details about table sts_allmo
SQL> DESC sts_allmo;
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- --------------
 MO_ID                                                 NOT NULL NUMBER(38)
 MO_TYPE                                                        VARCHAR2(255)
 MO_NAME                                                        VARCHAR2(4000)
 MO_ALIAS                                                       VARCHAR2(4000)
 CONTAINER_ID                                                   NUMBER(38)
 CONTAINER_TYPE                                                 VARCHAR2(255)
 CONTAINER_NAME                                                 VARCHAR2(255)
 CONTAINER_ALIAS                                                VARCHAR2(255)
 CONTAINER_VENDOR                                               VARCHAR2(255)


SQL>  select count(*) from sts_allmo;

  COUNT(*)
----------
      4615
I tried below query but no rows returned
SQL> SELECT * FROM STS_ALLMO INTERSECT SELECT x.port_id,
  2                     'HBA Port',
  3                     to_char(x.port_number),
  4                     x.adport_alias,
  5                     hwcontainer.hwcontainerid,
  6                     'Host',
  7                     hwcontainer.hwcontainerserialnumber,
  8                      DECODE (hwcontainer.aliasname,
  9                     NULL, hwcontainer.hwcontainerserialnumber,
 10                     hwcontainer.aliasname
 11                             ),
 12                     hwcontainer.vendorname
 13                FROM  hwcontainer,host,sts_host_hba x
 14                WHERE host.physicalserverid = hwcontainer.hwcontainerid
 15                AND   host.hostid = x.host_id;

no rows selected
  • 1. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    rp0428 Guru
    Currently Being Moderated
    Query the PORT_ID values from STS_HOST_HBA that are already in STS_ALLMO
    SELECT S.* FROM STS_HOST_HBA S, STS_ALLMO A
    WHERE S.PORT_ID = A.MO_ID
    Those rows already have an MO_ID value in STS_ALLMO
  • 2. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    sb92075 Guru
    Currently Being Moderated
    SELECT MO_ID FROM STS_ALLMO
    WHERE MO_ID IN (select port_id from STS_HOST_HBA)
  • 3. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    €$ħ₪ Expert
    Currently Being Moderated
    Find here
    
      SELECT COUNT (*), o.mo_id
        FROM hwcontainer,
             HOST,
             sts_host_hba x,
             sts_allmo o
       WHERE     HOST.physicalserverid = hwcontainer.hwcontainerid
             AND HOST.hostid = x.host_id
             AND port_id = o.mo_id
    GROUP BY mo_id
  • 4. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    993159 Newbie
    Currently Being Moderated
    Same . No rows returned
    SQL> SELECT MO_ID FROM STS_ALLMO
      2  WHERE MO_ID IN (select port_id from STS_HOST_HBA);
    
    no rows selected
    May be some other columns values is conflicting . I too initially suspected PORT_ID but through excel sheet i found out there are no duplicate values b/w MO_ID(STS_ALLMO) and PORT_ID(STS_HOST_HBA)
  • 5. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    993159 Newbie
    Currently Being Moderated
    Same result
    SQL> SELECT COUNT (*), o.mo_id
      2      FROM hwcontainer,
      3           HOST,
      4           sts_host_hba x,
      5           sts_allmo o
      6     WHERE     HOST.physicalserverid = hwcontainer.hwcontainerid
      7           AND HOST.hostid = x.host_id
      8           AND port_id = o.mo_id
      9  GROUP BY mo_id;
    
    no rows selected
  • 6. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    993159 Newbie
    Currently Being Moderated
    Hi,

    Is there any way to find out the duplicate records in the below query. there has to be duplicate records here
    INSERT INTO sts_allmo
      2  SELECT port_id,
      3                     'HBA Port',
      4                     to_char(x.port_number),
      5                     x.adport_alias,
      6                     hwcontainer.hwcontainerid,
      7                     'Host',
      8                     hwcontainer.hwcontainerserialnumber,
      9                      DECODE (hwcontainer.aliasname,
     10                     NULL, hwcontainer.hwcontainerserialnumber,
     11                     hwcontainer.aliasname
     12                             ),
     13                     hwcontainer.vendorname
     14                FROM  hwcontainer,host,sts_host_hba x
     15                WHERE host.physicalserverid = hwcontainer.hwcontainerid
     16                AND   host.hostid = x.host_id;
  • 7. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    sb92075 Guru
    Currently Being Moderated
    select port_id, count(*)
    from STS_HOST_HBA
    group by port_id
    having count(*) > 1;
  • 8. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    993159 Newbie
    Currently Being Moderated
    got it., thanks a lot
    SQL> select port_id, count(*)
      2  from STS_HOST_HBA
      3  group by port_id
      4  having count(*) > 1;
    
       5636697          2
       5636728          2
    One more thing how can i keep one record and delete the other one i.e. duplicate ?
  • 9. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    sb92075 Guru
    Currently Being Moderated
    990156 wrote:
    got it., thanks a lot
    SQL> select port_id, count(*)
    2  from STS_HOST_HBA
    3  group by port_id
    4  having count(*) > 1;
    
    5636697          2
    5636728          2
    One more thing how can i keep one record and delete the other one i.e. duplicate ?
    is every column identical?
    if so, delete based upon MIN or MAX rowid
    if not, select the row you want based upon unique column & delete the other
  • 10. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    1006154 Newbie
    Currently Being Moderated
    Hi~.
    delete from STA_HOST_HBA
    where rowid in (select max(rowid) 
                           from  STA_HOST_HBA
                           group by port_id
                           having count(*) > 1);
  • 11. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    993159 Newbie
    Currently Being Moderated
    HI,

    it fails with below error. WILL THE DELETE FROM will work as SELECT got failed ?
    SQL> select * from STS_HOST_HBA
      2  where rowid in (select max(rowid)
      3                         from  STS_HOST_HBA
      4                         group by port_id
      5                         having count(*) > 1);
    select * from STS_HOST_HBA
                  *
    ERROR at line 1:
    ORA-01445: cannot select ROWID from, or sample, a join view without a
    key-preserved table
    
    
    
    SQL> SELECT OWNER,OBJECT_TYPE FROM DBA_OBJECTS WHERE OBJECT_NAME='STS_HOST_HBA';
    
    OWNER                          OBJECT_TYPE
    ------------------------------ -------------------
    STSSYS                         VIEW
    STS                            SYNONYM
    STSVIEW                        VIEW
  • 12. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    1006154 Newbie
    Currently Being Moderated
    Hi.
    Could you provide the result of below query?
    SQL> set long 10000
    SQL> select text from dba_views where view_name='STS_HOST_HBA' and owner=&owner;
    
    SQL> select table_name, constraint_name
    from   dba_constraints
    where  table_name in ('tablename1', 'tablename2', .....) -- tables in the view.
    and    owner=&owner
    and    constraint_type='P'
  • 13. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    993159 Newbie
    Currently Being Moderated
    Since STS_HOST_HBA is a view,is there anyway to delete the duplicate record based on column PORT_ID from this view ?

    Below the details
    SQL> select text from dba_views where view_name='STS_HOST_HBA' and owner='STSSYS';
    
    TEXT
    --------------------------------------------------------------------------------
    SELECT adapter.adapterid, adapter.adaptername,
              CASE WHEN (adapternumber < 0)
                 THEN NULL
                 ELSE adapternumber
              END AS adapter_number, HOST.hostid,
              HOST.hostdisplayname,
              nvl(host.aliasname, nvl(hostdisplayname, hostname)),
              fibreadapter.nodewwn, adapter.numports, adapter.vendor,
              adapter.revision, adapter.model, v_sts_hwport.port_id,
              v_sts_hwport.port_number port_number,
              v_sts_hwport.port_alias adport_alias, v_sts_hwport.port_wwn,
    
    TEXT
    --------------------------------------------------------------------------------
              v_sts_hwport.port_wwnnickname,
              v_sts_hwport.iscsi_name, adapter.softwarerevision,
              sts_udf_values.customfield1, sts_udf_values.customfield2,
              sts_udf_values.customfield3, sts_udf_values.customfield4,
              sts_udf_values.customfield5, sts_udf_values.customfield6,
              sts_udf_values.customfield7, sts_udf_values.customfield8,
              sts_udf_values.customfield9, sts_udf_values.customfield10
         FROM HOST,
              physicalserver,
              v_sts_hwport,
              adapter,
    
    TEXT
    --------------------------------------------------------------------------------
              fibreadapter,
              hwportmedium,
              sts_udf_values
        WHERE HOST.physicalserverid = physicalserver.physicalserverid
          AND host.entitytypecode not like 'Nas%'
          AND adapter.hwcontainerid = physicalserver.physicalserverid
          AND adapter.adapterid = fibreadapter.fibreadapterid(+)
          AND adapter.adapterid = v_sts_hwport.adapter_id
          AND adapter.adapterid = sts_udf_values.moid(+)
          AND v_sts_hwport.port_id = hwportmedium.hwportid(+)
          AND hwportmedium.hwportmediumtype NOT IN ('ScsiPortMedium')
    
    TEXT
    --------------------------------------------------------------------------------
    
    
    
    SQL> SELECT OWNER,OBJECT_TYPE,STATUS,OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_NAME in ('HOST','PHYSICALSERVER','V_STS_HWPORT','ADAPTER','FIBREADAPTER','HWPORTMEDIUM','STS_UDF_VALUES') order by OBJE
    _NAME;
    
    OWNER           OBJECT_TYPE         STATUS  OBJECT_NAME
    --------------- ------------------- ------- --------------------------------------------------------------------------------------------------------------------------------
    ECCSTAGING      TABLE               VALID   ADAPTER
    ECCCONSOLE      SYNONYM             VALID   ADAPTER
    STSSYS          SYNONYM             VALID   ADAPTER
    ECC             SYNONYM             VALID   ADAPTER
    ECCSYS          TABLE               VALID   ADAPTER
    ECC             SYNONYM             VALID   FIBREADAPTER
    ECCSYS          TABLE               VALID   FIBREADAPTER
    ECCCONSOLE      SYNONYM             VALID   FIBREADAPTER
    STSSYS          SYNONYM             VALID   FIBREADAPTER
    ECCSTAGING      TABLE               VALID   FIBREADAPTER
    STSSYS          SYNONYM             VALID   HOST
    ECCSYS          TABLE               VALID   HOST
    ECCSTAGING      SYNONYM             VALID   HOST
    ECCCONSOLE      SYNONYM             VALID   HOST
    ECC             SYNONYM             VALID   HOST
    ECCSTAGING      TABLE               VALID   HWPORTMEDIUM
    ECCSYS          TABLE               VALID   HWPORTMEDIUM
    ECC             SYNONYM             VALID   HWPORTMEDIUM
    ECCCONSOLE      SYNONYM             VALID   HWPORTMEDIUM
    STSSYS          SYNONYM             VALID   HWPORTMEDIUM
    ECCSYS          TABLE               VALID   PHYSICALSERVER
    ECC             SYNONYM             VALID   PHYSICALSERVER
    ECCCONSOLE      SYNONYM             VALID   PHYSICALSERVER
    STSSYS          SYNONYM             VALID   PHYSICALSERVER
    ECCSTAGING      SYNONYM             VALID   PHYSICALSERVER
    STS             SYNONYM             VALID   STS_UDF_VALUES
    STSSYS          TABLE               VALID   STS_UDF_VALUES
    STSVIEW         VIEW                VALID   STS_UDF_VALUES
    STSSYS          VIEW                VALID   V_STS_HWPORT
    STS             SYNONYM             VALID   V_STS_HWPORT
    
    30 rows selected.
    set line 1000
    set pagesize 1000
    col column_name format a30;
    col owner format a15;
    
    select    decode(a.constraint_type,
            'C', 'Check',
            'O', 'R/O View',
            'P', 'Primary',
            'R', 'Foreign',
            'U', 'Unique',
            'V', 'Check view') type ,    a.constraint_name ,a.status,b.column_name,a.owner, a.status, a.last_change,a.table_name
    from    dba_constraints a, DBA_CONS_COLUMNS b
    where a.table_name = b.table_name 
    and a.constraint_name =b.constraint_name 
    and a.owner=b.owner
    and     a.table_name in ('HOST','PHYSICALSERVER','V_STS_HWPORT','ADAPTER','FIBREADAPTER','HWPORTMEDIUM','STS_UDF_VALUES')
    order by 8,5,1 ;
    
    
    
    TYPE       CONSTRAINT_NAME                STATUS   COLUMN_NAME                    OWNER           STATUS   LAST_CHAN TABLE_NAME
    ---------- ------------------------------ -------- ------------------------------ --------------- -------- --------- ----------------
    Check      SYS_C0038674                   ENABLED  ADAPTERID                      ECCSTAGING      ENABLED  02-MAY-13 ADAPTER
    Check      SYS_C0038675                   ENABLED  ADAPTERNUMBER                  ECCSTAGING      ENABLED  02-MAY-13 ADAPTER
    Foreign    FK1ADAPTER_PARENTADAPTERID     ENABLED  PARENTADAPTERID                ECCSTAGING      ENABLED  02-MAY-13 ADAPTER
    Foreign    FK3ADAPTER_HOSTID              ENABLED  HOSTID                         ECCSTAGING      ENABLED  02-MAY-13 ADAPTER
    Foreign    FK2ADAPTER_HWCONTAINERID       ENABLED  HWCONTAINERID                  ECCSTAGING      ENABLED  02-MAY-13 ADAPTER
    Foreign    FK9_ADAPTER_SRCTYPEID          ENABLED  DATASOURCETYPEID               ECCSTAGING      ENABLED  02-MAY-13 ADAPTER
    Primary    PK_ADAPTER                     ENABLED  ADAPTERID                      ECCSTAGING      ENABLED  02-MAY-13 ADAPTER
    
    
    Check      SYS_C0036951                   ENABLED  ADAPTERID                      ECCSYS          ENABLED  02-MAY-13 ADAPTER
    Check      SYS_C0036952                   ENABLED  ADAPTERNUMBER                  ECCSYS          ENABLED  02-MAY-13 ADAPTER
    Foreign    FK3ADAPTER_HOSTID              ENABLED  HOSTID                         ECCSYS          ENABLED  02-MAY-13 ADAPTER
    Foreign    FK2ADAPTER_HWCONTAINERID       ENABLED  HWCONTAINERID                  ECCSYS          ENABLED  02-MAY-13 ADAPTER
    Foreign    FK1ADAPTER_PARENTADAPTERID     ENABLED  PARENTADAPTERID                ECCSYS          ENABLED  02-MAY-13 ADAPTER
    Foreign    FK9_ADAPTER_SRCTYPEID          ENABLED  DATASOURCETYPEID               ECCSYS          ENABLED  02-MAY-13 ADAPTER
    Primary    PK_ADAPTER                     ENABLED  ADAPTERID                      ECCSYS          ENABLED  02-MAY-13 ADAPTER
    
    
    Check      SYS_C0038744                   ENABLED  FIBREADAPTERID                 ECCSTAGING      ENABLED  02-MAY-13 FIBREADAPTER
    Foreign    FK1FIBREADAPTER_FIBREADAPTERID ENABLED  FIBREADAPTERID                 ECCSTAGING      ENABLED  02-MAY-13 FIBREADAPTER
    Primary    PK_FIBREADAPTER                ENABLED  FIBREADAPTERID                 ECCSTAGING      ENABLED  02-MAY-13 FIBREADAPTER
    
    Check      SYS_C0037439                   ENABLED  FIBREADAPTERID                 ECCSYS          ENABLED  02-MAY-13 FIBREADAPTER
    Foreign    FK1FIBREADAPTER_FIBREADAPTERID ENABLED  FIBREADAPTERID                 ECCSYS          ENABLED  02-MAY-13 FIBREADAPTER
    Primary    PK_FIBREADAPTER                ENABLED  FIBREADAPTERID                 ECCSYS          ENABLED  02-MAY-13 FIBREADAPTER
    
    Check      SYS_C0037596                   ENABLED  PHYSICALSERVERID               ECCSYS          ENABLED  02-MAY-13 HOST
    Check      SYS_C0037598                   ENABLED  HOSTID                         ECCSYS          ENABLED  02-MAY-13 HOST
    Check      SYS_C0037597                   ENABLED  HOSTNAME                       ECCSYS          ENABLED  02-MAY-13 HOST
    Foreign    FK9_HOST_SRCTYPEID             ENABLED  DATASOURCETYPEID               ECCSYS          ENABLED  02-MAY-13 HOST
    Foreign    FK1HOST_ESXSERVERID            ENABLED  ESXSERVERID                    ECCSYS          ENABLED  02-MAY-13 HOST
    Foreign    FK3HOST_PHYSICALSERVERID       ENABLED  PHYSICALSERVERID               ECCSYS          ENABLED  02-MAY-13 HOST
    Foreign    FK4HOST_HOSTCLUSTERID          ENABLED  HOSTCLUSTERID                  ECCSYS          ENABLED  02-MAY-13 HOST
    Foreign    FK2HOST_OPSYSID                ENABLED  OPSYSID                        ECCSYS          ENABLED  02-MAY-13 HOST
    Primary    PK_HOST                        ENABLED  HOSTID                         ECCSYS          ENABLED  02-MAY-13 HOST
    
    Check      SYS_C0038776                   ENABLED  HWPORTMEDIUMID                 ECCSTAGING      ENABLED  02-MAY-13 HWPORTMEDIUM
    Foreign    FK2HWPORTMEDIUM_HWPORTID       ENABLED  HWPORTID                       ECCSTAGING      ENABLED  02-MAY-13 HWPORTMEDIUM
    Foreign    FK1HWPORTMEDIUM_PORTWWNID      ENABLED  PORTWWNID                      ECCSTAGING      ENABLED  02-MAY-13 HWPORTMEDIUM
    Foreign    FK3HWPORTMEDIUM_FABRICID       ENABLED  FABRICID                       ECCSTAGING      ENABLED  02-MAY-13 HWPORTMEDIUM
    Primary    PK_HWPORTMEDIUM                ENABLED  HWPORTMEDIUMID                 ECCSTAGING      ENABLED  02-MAY-13 HWPORTMEDIUM
    
    Check      SYS_C0037704                   ENABLED  HWPORTMEDIUMID                 ECCSYS          ENABLED  02-MAY-13 HWPORTMEDIUM
    Foreign    FK3HWPORTMEDIUM_FABRICID       ENABLED  FABRICID                       ECCSYS          ENABLED  02-MAY-13 HWPORTMEDIUM
    Foreign    FK2HWPORTMEDIUM_HWPORTID       ENABLED  HWPORTID                       ECCSYS          ENABLED  02-MAY-13 HWPORTMEDIUM
    Foreign    FK1HWPORTMEDIUM_PORTWWNID      ENABLED  PORTWWNID                      ECCSYS          ENABLED  02-MAY-13 HWPORTMEDIUM
    Primary    PK_HWPORTMEDIUM                ENABLED  HWPORTMEDIUMID                 ECCSYS          ENABLED  02-MAY-13 HWPORTMEDIUM
    
    Check      SYS_C0038012                   ENABLED  PHYSICALSERVERID               ECCSYS          ENABLED  02-MAY-13 PHYSICALSERVER
    Foreign    FK1PHYSICALSERVER_PHYSICALSERV ENABLED  PHYSICALSERVERID               ECCSYS          ENABLED  02-MAY-13 PHYSICALSERVER
    Primary    PK_PHYSICALSERVER              ENABLED  PHYSICALSERVERID               ECCSYS          ENABLED  02-MAY-13 PHYSICALSERVER
  • 14. Re: ORA-00001: unique constraint (STSSYS.SYS_C0038626) violated
    1006154 Newbie
    Currently Being Moderated
    Thanks for your information.
    The PORT_ID column exists in the V_STS_HWPORT view.
    so, could you retry search to dba_views?
    SQL> set long 10000
    SQL> select text from dba_views where view_name='V_STS_HWPORT' and owner=&owner;
    Edited by: seankim on 2013. 5. 3 오후 3:40
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points