Originally posted by DaPi
Hi Abhay,
Did the index exist before the PK constraint was added? The PK is handled a bit differently if you do that.
No, index was created along with PK.. See below DDL

Code:
CREATE TABLE RLSCSHEV
(
SALES_ORGANIZATION_CD           VARCHAR2(4)   ,
SHIPMENT_NO                    	VARCHAR2(10)  ,
PARTNER_FUNCTION_CD            	VARCHAR2(3)   ,
SOURCE_NM                      	VARCHAR2(16)  ,
EVENT_SPEC_SUPPLIER_NO         	VARCHAR2(10)  ,
EVENT_SPEC_PARTNER_CONTACT_NO  	VARCHAR2(17)  ,
EVENT_SPECIFIC_LANGUAGE_CD     	VARCHAR2(1)   ,
EVENT_SPECIFIC_TITLE_TX        	VARCHAR2(15)  ,
EV_SPEC_DOING_BUSINESS_AS_NM   	VARCHAR2(35)  ,
EVENT_SPEC_CUSTOMER_LEGAL_NM   	VARCHAR2(35)  ,
EV_SPEC_CUST_LEGAL_OVRFLW_NM   	VARCHAR2(35)  ,
EVENT_SPEC_STREET_AD           	VARCHAR2(35)  ,
EVENT_SPEC_POSTAL_CD           	VARCHAR2(10)  ,
EVENT_SPEC_CITY_NM             	VARCHAR2(35)  ,
EVENT_SPEC_POST_OFFICE_BOX_TX  	VARCHAR2(10)  ,
EVENT_SPEC_TELEPHONE_NO        	VARCHAR2(30)  ,
EVENT_SPEC_FAX_NO              	VARCHAR2(31)  ,
EVENT_SPEC_PO_BOX_POSTAL_CD    	VARCHAR2(10)  ,
EVENT_SPEC_COUNTRY_CD          	VARCHAR2(3)   ,
EVENT_SPEC_HOUSE_NO            	VARCHAR2(6)   ,
EVENT_SPEC_REGION_CD           	VARCHAR2(3)   ,
SOURCE_DT                      	VARCHAR2(15)  ,
EVENT_SPEC_DISTRICT_CD         	VARCHAR2(35)  ,
EVENT_SPEC_STREET_2_AD         	VARCHAR2(35)  ,
EVENT_SPEC_STREET_AD_OVRFLWX   	VARCHAR2(35)  ,
EVENT_SPEC_TELEX_NO            	VARCHAR2(30)  ,
EVENT_SPEC_TAX_JURISDICTION_CD 	VARCHAR2(15)  ,
CONSTRAINT PK_RLSCSHEV
PRIMARY KEY ( SALES_ORGANIZATION_CD, SHIPMENT_NO, PARTNER_FUNCTION_CD, SOURCE_NM )
	USING INDEX
		TABLESPACE CAS_IDX_1 PCTFREE 10
		STORAGE ( INITIAL 10M NEXT 10M PCTINCREASE 0 ))
TABLESPACE CAS_TAB_1 NOLOGGING 
   PCTFREE 10
   PCTUSED 60
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 50M
   NEXT    50M
   MINEXTENTS 1
   PCTINCREASE 0
   MAXEXTENTS 255
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE;
However, when Primary Key is added later using Alter Command, it will check for any null values and if not found any then update the column and make it "NOT NULL"

Abhay.