Oracel-SQL Question
From: Virinchipuram J. A. <fbap3120_at_leonis.nus.sg>
Date: 15 Sep 1994 11:05:23 GMT
Message-ID: <3599pj$t3p_at_nuscc.nus.sg>
National University Of Singapore Received on Thu Sep 15 1994 - 13:05:23 CEST
Date: 15 Sep 1994 11:05:23 GMT
Message-ID: <3599pj$t3p_at_nuscc.nus.sg>
I am using SQL-plus for windows I have created a table- Create Table Company_Profile ( Company_code NUMBER(4) NOT NULL, Date_of_Joinig DATE, Primary Key (Company_code) ) Create Unique Index company_profile_index ON Company_Profile (Company_Code) The above two have succeded. But when I say- Drop Index company_profile_index it gives me an error saying no such index. But I checked the table structure, by attaching this in MS-Access and when I check the name of the index, it is Username_SYS_c00345 In other words Oracle has given a different name to the index. The index is not named as company_profile_index Can anyone shed Light on this? Thanks for the effort. -- Anand. V. J Internet:fbap3120_at_leonis.nus.sgDept Of Decision Sciences
National University Of Singapore Received on Thu Sep 15 1994 - 13:05:23 CEST