Table 3-1 lists the database changes that were included in 6.0.15 and 6.0.16 patches, and the 6.2.0 release. For changes delivered in patches, the build number where the change was first introduced is referenced. If you have installed 6.0.x, refer to the build number to determine if you have already implemented the changes that are listed.
Table 3-1 Database Changes in 6.0.15 and 6.0.16 Patches, and the 6.2.0 Release
Release | Prodfixsql File | Change | SQL |
---|---|---|---|
6.0.15.b256 |
CR119347.sql |
New Table |
alter table INTEGRATION_EVENT_STATUS drop constraint FK_IN_EV_ST__SR_GA_EV / alter table INTEGRATION_EVENT_STATUS add constraint FK_IN_EV_ST__SR_GA_EV foreign key (SRSI_GATEWAY_EVENT_ID, SRSI_DOCUMENT_NUMBER, SRSI_SERV_ITEM_ID,SRSI_TASK_NUMBER) references SRSI_GATEWAY_EVENT (GATEWAY_EVENT_ID, DOCUMENT_NUMBER,SERV_ITEM_ID, TASK_NUMBER) ON DELETE CASCADE' / |
6.0.15.b645 |
9462631.sql |
Modify Columns |
alter table ASSIGNED_TEL_NUM modify (ATN_ID Number(10,0)) / alter table ATN_CNAM modify (ATN_ID Number (10,0)) / alter table ATN_LIDB modify (ATN_ID Number (10,0)) / alter table ATN_PIC modify (ATN_ID Number (10,0)) / alter table ATN_RCF_NP_INFO modify (ATN_ID Number (10,0)) / alter table INTERCEPT_INFO modify (ATN_ID Number (10,0)) / alter table SPLIT_INTERCEPT modify (ATN_ID Number (10,0)) / alter table NI_ASSIGNED_ITN modify (NI_ATN_ID NUMBER(10,0)) / |
6.0.15.b714 |
10041045.sql |
Modify Columns |
alter table NI_IP_RULE modify (NI_USE_NBR_CD Number(4)) / alter table NI_USE_GRP_NBR_INV modify (NI_USE_NBR_CD Number(4)) / alter table NI_USE_GRP_FUNCT_AREA modify (NI_USE_NBR_CD Number(4)) / alter table NI_USE modify (NI_USE_NBR_CD Number(4)) / |
6.0.15.b736 |
8374339.sql |
Modify Columns |
alter table ASAP.SERV_REQ add NPA VarChar2(3) null / alter table ASAP.SERV_REQ add NXX VarChar2(3) null / |
6.0.16.b226 |
Bug7632057.sql |
New Columns |
alter table ACI_SRSI add TELECOM_SERVICE_PRIORITY VarChar2(12) null / |
6.0.16.b309 |
B8200289.sql |
New Columns |
alter table NS_NETWORK_SYSTEM add NS_PROTECT_TYPE VarChar2(15) null / |
6.0.16.b317 |
8448397.sql |
New Columns |
alter table SPECIAL_ACCESS add SWITCHED_ETHERNET_INDICATOR Char(1) null / alter table TQ_SAC_ACTIVITY_INFORMATION add SERVICE_ACCESS_CODE Number(3) null / |
6.0.16.b348 |
8760811.sql |
New Table |
create table DEFAULT_OPA_CRITERIA ( GA_INSTANCE_ID_ORIG Number(9) not null, GA_INSTANCE_ID_TERM Number(9) not null, INCLUDE_CRITERIA VarChar2 (200) null, EXCLUDE_CRITERIA VarChar2 (200) null, LAST_MODIFIED_USERID VarChar2 (8) not null, LAST_MODIFIED_DATE Date not null ) Tablespace DATA / |
6.0.16.b348 |
8760811.sql |
New Constraint |
alter table DEFAULT_OPA_CRITERIA add constraint PFXPK_DEFAULT_OPA_CRITERIA primary key (GA_INSTANCE_ID_ORIG, GA_INSTANCE_ID_TERM) / alter table DEFAULT_OPA_CRITERIA add constraint PFXFK_DEF_OPA_CRIT__GA_INST1 foreign key (GA_INSTANCE_ID_ORIG) references GA_INSTANCE (GA_INSTANCE_ID) / alter table DEFAULT_OPA_CRITERIA add constraint PFXFK_DEF_OPA_CRIT__GA_INST2 foreign key (GA_INSTANCE_ID_TERM) references GA_INSTANCE (GA_INSTANCE_ID) / |
6.0.16.b348 |
8760811.sql |
New Synonym |
Create Public Synonym DEFAULT_OPA_CRITERIA for asap.DEFAULT_OPA_CRITERIA / |
6.0.16.b384 |
9023783.sql |
New Table |
create table PARTITION_GROUP ( PARTITION_GROUP_ID Number(9) not null, PARTITION_GROUP_NAME VarChar2 (30) not null, PARTITION_GROUP_DESC VarChar2 (100) null, SYSTEM_IND Char (1) not null, LAST_MODIFIED_USERID VarChar2 (32) not null, LAST_MODIFIED_DATE Date not null ) Tablespace DATA / create table PARTITION_SECURITY_USERS ( PARTITION_GROUP_ID Number(9) not null, NAME VarChar2 (16) not null, STATUS Char (1) not null, LAST_MODIFIED_USERID VarChar2 (32) not null, LAST_MODIFIED_DATE Date not null ) Tablespace DATA / |
6.0.16.b384 |
9023783.sql |
New Columns |
alter table CIRCUIT add PARTITION_GROUP_ID Number(9) null / alter table NS_NETWORK_SYSTEM add PARTITION_GROUP_ID Number(9) null / alter table EQUIPMENT add PARTITION_GROUP_ID Number(9) null / alter table TFC_NETWORK add PARTITION_GROUP_ID Number(9) null / |
6.0.16.b384 |
9023783.sql |
New Constraint |
alter table PARTITION_GROUP add constraint PFXPK_PARTITION_GROUP primary key (PARTITION_GROUP_ID) / alter table PARTITION_SECURITY_USERS add constraint PFXFK_PAR_SECU__SECU_USERS foreign key (NAME) references SECURITY_USERS (NAME) / alter table PARTITION_SECURITY_USERS add constraint PFXFK_PAR_SECU__PART_GROUP foreign key (PARTITION_GROUP_ID) references PARTITION_GROUP (PARTITION_GROUP_ID) / alter table CIRCUIT add constraint PFXFK_CIRCUIT__PART_GROUP foreign key (PARTITION_GROUP_ID) references PARTITION_GROUP (PARTITION_GROUP_ID) / alter table NS_NETWORK_SYSTEM add constraint PFXFK_NS_NETW_SYS__PART_GROUP foreign key (PARTITION_GROUP_ID) references PARTITION_GROUP (PARTITION_GROUP_ID) / alter table EQUIPMENT add constraint PFXFK_EQUIPMENT__PART_GROUP foreign key (PARTITION_GROUP_ID) references PARTITION_GROUP (PARTITION_GROUP_ID) / alter table TFC_NETWORK add constraint PFXFK_TFC_NETW__PART_GROUP foreign key (PARTITION_GROUP_ID) references PARTITION_GROUP (PARTITION_GROUP_ID) / |
6.0.16.b384 |
9023783.sql |
New sequence |
create sequence SQ_PARTITION_GROUP INCREMENT BY 1 START WITH 10000 MINVALUE 10000 MAXVALUE 999999999999999999999999999 NOCYCLE NOORDER CACHE 20 / |
6.0.16.b384 |
9023783.sql |
New Synonym |
Create Public Synonym PARTITION_GROUP for ASAP.PARTITION_GROUP / Create Public Synonym PARTITION_SECURITY_USERS for ASAP.PARTITION_SECURITY_USERS / Create Public Synonym SQ_PARTITION_GROUP for ASAP.SQ_PARTITION_GROUP / |
6.0.16.b484 |
9559056.sql |
New Table |
create table FOC_EVC_DETAIL ( DOCUMENT_NUMBER Number(9) not null, EVC_NBR VarChar2 (4) not null, FOC_DESIGN_ID Number(9) not null, EVC_ID VarChar2 (28) null, EVC_ORD VarChar2 (17) null, EVC_CKR VarChar2 (53) null, LAST_MODIFIED_USERID VarChar2 (32) not null, LAST_MODIFIED_DATE Date not null ) Tablespace DATA / |
6.0.16.b484 |
9559056.sql |
New Columns |
alter table ACCESS_SERVICE_REQUEST add SERVICE_RESERVATION_NUMBER VarChar2 (15) null / alter table ACCESS_SERVICE_REQUEST add SECONDARY_CONNECT_FAC_USE Char (1) null / alter table SPECIAL_ACCESS add DIVERSE_CIRCUIT_ID VarChar2(36) null / alter table SPECIAL_ACCESS add DIVERSE_PON VarChar2(16) null / alter table ACI_SRSI add SECONDARY_CONNECT_FAC_USE Char(1) null / alter table ACI_SRSI add DIVERSE_CIRCUIT_ID VarChar2(36) null / alter table ACI_SRSI add DIVERSE_PON VarChar2(16) null / alter table ACI_SRSI add IP_ADDRESS VarChar2(15) null / alter table ACI_SRSI add SUBNET_MASK VarChar2(15) null / alter table ACR_SRSI add IP_ADDRESS VarChar2(15) null / alter table ACR_SRSI add SUBNET_MASK VarChar2(15) null / alter table FIRM_ORDER_CONFIRMATION add SERVICE_RESERVATION_NUMBER VarChar2(15) null / alter table EVC_DETAIL add EVC_CKR VarChar2(53) null / alter table EVC_UNI_MAP add ASSOC_UNI_NNI_TERM Char(1) null / |
6.0.16.b484 |
9559056.sql |
New Constraint |
alter table FOC_EVC_DETAIL add constraint PFXPK_FOC_EVC_DETAIL primary key (DOCUMENT_NUMBER, EVC_NBR) / alter table FOC_EVC_DETAIL add constraint PFXFK_EVC_DETAIL__FOC_EVC_DET foreign key (DOCUMENT_NUMBER, EVC_NBR) references EVC_DETAIL (DOCUMENT_NUMBER, EVC_NBR) / |
6.0.16.b484 |
9559056.sql |
New Synonym |
Create Public Synonym FOC_EVC_DETAIL for ASAP.FOC_EVC_DETAIL / |
6.0.16.b495 |
9692262_SAC.sql |
Modify Columns |
alter table TQ_SAC_ACTIVITY_INFORMATION modify SERVICE_ACCESS_CODE Number(3) NOT NULL / alter table TQ_SAC_NXX add SERVICE_ACCESS_CODE Number(3) not null / alter table TQ_SAC_ACTIVITY_INFORMATION modify (SAC_ACTIVITY_NUMBER NULL) / alter table TQ_SAC_NXX modify (SAC_ACTIVITY_NUMBER NULL) / |
6.0.16.b495 |
9692262_SAC.sql |
Modify Constraints |
alter table TQ_SAC_ACTIVITY_INFORMATION Drop constraint PK_TQ_SAC_ACTIVITY_INFORMATION / alter table TQ_SAC_ACTIVITY_INFORMATION Add constraint PK_TQ_SAC_ACTIVITY_INFORMATION primary key (DOCUMENT_NUMBER, SERVICE_ACTIVITY_ACTION, SERVICE_ACCESS_CODE) / alter table TQ_SAC_NXX Drop constraint FK_TSN_SAC_NXX / alter table TQ_SAC_NXX add constraint FK_TSN_SAC_NXX foreign key (DOCUMENT_NUMBER, SERVICE_ACTIVITY_ACTION, SERVICE_ACCESS_CODE) references TQ_SAC_ACTIVITY_INFORMATION (DOCUMENT_NUMBER, SERVICE_ACTIVITY_ACTION, SERVICE_ACCESS_CODE) / alter table TQ_SAC_NXX Drop constraint PK_TQ_SAC_NXX / alter table TQ_SAC_NXX Add constraint PK_TQ_SAC_NXX primary key (DOCUMENT_NUMBER, SERVICE_ACTIVITY_ACTION, SAC_NXX, SERVICE_ACCESS_CODE) / alter table TQ_SAC_NXX Drop constraint CK_FK_TSN_SAC_NXX / alter table TQ_SAC_NXX add constraint CK_FK_TSN_SAC_NXX check ((DOCUMENT_NUMBER is null and SERVICE_ACTIVITY_ACTION IS NULL AND SAC_NXX is null and SERVICE_ACCESS_CODE is null) or (DOCUMENT_NUMBER is not null AND SERVICE_ACTIVITY_ACTION is not null AND SAC_NXX is not null AND SERVICE_ACCESS_CODE is not null)) / |
6.0.16.b495 |
9692262_SAC.sql |
Modify Index |
drop index TQ_SAC_ACTIVITY_INFORMATION_PK / create unique Index TQ_SAC_ACTIVITY_INFORMATION_PK on TQ_SAC_ACTIVITY_INFORMATION (DOCUMENT_NUMBER, SERVICE_ACTIVITY_ACTION, SERVICE_ACCESS_CODE) / |
6.0.16.b526 |
9436758.sql |
New Type |
Create Type ASAP.TY_TABLE_VC4_STRINGS as table of Varchar2(4) / |
6.0.16.b527 |
9414461.sql |
Modify Columns |
alter table NS_COMPONENT modify NS_COMP_ACRONYM VarChar2(50) / |
6.0.16.b528 |
10062929.sql |
Add Columns |
alter table CIRCUIT_XREF add LOCATION_ID Number(9) / |
6.0.16.b542 |
9812149.sql |
New Table |
create table PORT_ADDR_CA_VALUE ( PORT_ADDR_CA_VALUE_ID Number(10,0) not null, EQUIPMENT_ID Number(10,0) not null, PORTADDR_SEQ Number(10,0) not null, CA_VALUE Varchar2(1500) not null CA_VALUE_LABEL Varchar2 (50) not null, CA_VALUE_UOM Varchar2 (32) null, CA_USAGE_ID Number(10,0) not null, CA_USAGE_VV_ID Number (10,0) null, MS_BB_ID Number (10,0) not null, CURRENT_ROW_IND Char(1) not null, CA_ID Number(10,0) not null, LAST_MODIFIED_DATE Date not null LAST_MODIFIED_USERID VarChar2 (32) not null, ) Tablespace DATA / |
6.0.16.b542 |
9812149.sql |
New Columns |
alter table EQUIPMENT_SPEC add MS_BB_ID_PA Number(10,0) null / |
6.0.16.b542 |
9812149.sql |
New sequence |
create sequence SQ_PORT_ADDR_CA_VALUE INCREMENT BY 1 START WITH 10000 MINVALUE 10000 MAXVALUE 999999999999999999999999999 NOCYCLE NOORDER CACHE 20 / |
6.0.16.b542 |
9812149.sql |
New Synonym |
Create Public Synonym SQ_PORT_ADDR_CA_VALUE for SQ_PORT_ADDR_CA_VALUE / Create Public Synonym PORT_ADDR_CA_VALUE for ASAP.PORT_ADDR_CA_VALUE / |
6.0.16.b542 |
9812149.sql |
New Index |
create unique index PFXPK_PORT_ADDR_CA_VALUE on PORT_ADDR_CA_VALUE (PORT_ADDR_CA_VALUE_ID asc) / create index PFXI_PA_CA_VA__PA on PORT_ADDR_CA_VALUE (EQUIPMENT_ID asc, PORTADDR_SEQ asc) / create index PFXI_PA_CA_VA__CA_ID on PORT_ADDR_CA_VALUE (CA_ID asc, CA_VALUE asc) / create index PFXI_PA_CA_VA__CA_US on PORT_ADDR_CA_VALUE (CA_USAGE_ID asc) / create index PFXI_PA_CA_VA__MS_BU_BL on PORT_ADDR_CA_VALUE (MS_BB_ID asc) / create index PFXI_PA_CA_VAL__CA_US_ID on PORT_ADDR_CA_VALUE (CA_USAGE_ID asc, CA_VALUE asc, MS_BB_ID asc) / create index PFXI_PA_CA_VA__CA_US_VA_VA on PORT_ADDR_CA_VALUE (CA_USAGE_VV_ID asc) / |
6.0.16.b542 |
9812149.sql |
New Constraint |
alter table PORT_ADDR_CA_VALUE add constraint PFXPK_PORT_ADDR_CA_VALUE primary key (PORT_ADDR_CA_VALUE_ID) / alter table PORT_ADDR_CA_VALUE add constraint PFXFK_PA_CA_VA__CA_US foreign key (CA_USAGE_ID) references CA_USAGE (CA_USAGE_ID) / alter table PORT_ADDR_CA_VALUE add constraint PFXFK_PA_CA_VA__CA_US_VA_VA foreign key (CA_USAGE_VV_ID) references CA_USAGE_VALID_VALUE (CA_USAGE_VV_ID) / alter table PORT_ADDR_CA_VALUE add constraint PFXFK_PA_CA_VA__PA foreign key (EQUIPMENT_ID, PORTADDR_SEQ) references PORT_ADDRESS (EQUIPMENT_ID, PORTADDR_SEQ) / alter table PORT_ADDR_CA_VALUE add constraint PFXFK_PA_CA_VA__MS_BU_BL foreign key (MS_BB_ID) references MS_BUILDING_BLOCK (MS_BB_ID) / alter table PORT_ADDR_CA_VALUE add constraint PFXFK_PA_CA_VALUE__CA_CU_AT foreign key (CA_ID) references CA_CUSTOMIZED_ATTRIBUTE (CA_ID) / |
6.0.16.b586 |
10234378.sql |
Add Columns |
alter table SPECIAL_ACCESS add IP_ADDRESS Varchar2(15) null / alter table SPECIAL_ACCESS add SUBNET_MASK Varchar2(15) null / |
6.0.16.b586 |
10234378.sql |
Modify Columns |
alter table EVC_LVL_SERV modify DIFF_SERV_CD_POINT VarChar2(12) / |
6.2.0 GA |
9677791. sql |
New Index |
Create Index IDX_TA_JE_WH__DA_CL on TASK_JEOPARDY_WHYMISS (DATE_CLOSED asc, JEOPARDY_TYPE_CD asc, ORDER_JEOP_DOC_NUM asc) Tablespace INDEXES / |
6.2.0 GA |
8637316. sql |
New Table |
Create Table CREDENTIAL_STORE (CRED_NAME Varchar2(100 BYTE) NOT NULL ENABLE, CRED_WORD RAW(32), CONSTRAINT CREDENTIAL_STORE_PK PRIMARY KEY (CRED_NAME)) / Create PUBLIC SYNONYM CREDENTIAL_STORE FOR ASAP.CREDENTIAL_STORE / |