1 2 Previous Next 15 Replies Latest reply: May 3, 2013 6:30 PM by sb92075 RSS

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

    993159
      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
          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
            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
              €$ħ₪
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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