RENAME COLUMN SECURITYID1 to SECURITYID;

 alter table SDC_INDEXQUOTE add SECURITYID1 INTEGER;
 update SDC_INDEXQUOTE set SECURITYID1 = TO_NUMBER(SECURITYID);
 alter table SDC_INDEXQUOTE drop column SECURITYID;
 alter table SDC_INDEXQUOTE RENAME COLUMN SECURITYID1 to SECURITYID;
 create index I_SDCINDEXQUOTE01 on SDC_INDEXQUOTE (securityid, tradedate);