RE: ORA-00955: name is already used by an existing object
VARCHAR2(23) > UMBAUKOSTENVARCHAR2(23) > VERSCHLEISSSCHADENKOPF VARCHAR2(23) > VORGANGSDATEN VARCHAR2(23) > VORSCHAEDENVARCHAR2(23) > ZUORDNUNG VARCHAR2(23) > ZUSTANDVARCHAR2(23) > MESSWERTHERKUNFT NUMBER(10) > MESSWERTLISTAKTIV NUMBER(1) > FEHLENDETEILE VARCHAR2(23) > BEWERTUNGERGEBNIS VARCHAR2(23) > WERTKORREKTURENVARCHAR2(23) > BEMERKUNG VARCHAR2(4000) > NUMMER VARCHAR2(40) > VORGANGVARCHAR2(40) > AUDATEXUEBERNEHMEN NUMBER(1) > BAUMUSTER VARCHAR2(100) > HERSTELLER VARCHAR2(100) > NFZAUSSTATTUNG VARCHAR2(23) > RADSTAND1 NUMBER(10) > RADSTAND2 NUMBER(10) > VERKAUFSBEZEICHNUNGVARCHAR2(100) > FZALLGEMEINZUSTANDBEMERKUNGCLOB > FZALLGEMEINZUSTANDCBXCODE NUMBER(10) > NICHTMITBEWERTETETEILE CLOB > EREIGNISCBXVARCHAR2(40) > FAHRER VARCHAR2(20) > FAHRERORT VARCHAR2(30) > FAHRERSTRASSE VARCHAR2(30) > HERGANGSSCHILDERUNGCLOB > HERGANGSSCHILDERUNGLTCBX VARCHAR2(40) > NACHSCHADENANGABENCBX VARCHAR2(40) > NACHSCHADENBEMERKUNG CLOB > POLAUFNAHMEARTCBX VARCHAR2(40) > POLAUFNAHMEARTTEXT VARCHAR2(30) > POLAUFNAHMEDURCH VARCHAR2(30) > SCHADENORT VARCHAR2(30) > SCHADENSTRASSE VARCHAR2(30) > SCHADENUNFALLDATUMCBX VARCHAR2(40) > SCHADENUNFALLDATUMSTR VARCHAR2(10) > SCHADENUNFALLORT VARCHAR2(30) > VORGANGSBEMERKUNGENCLOB > UMBAUKOSTENBEMERKUNG CLOB > UMBAUKOSTENMMWST NUMBER > UMBAUKOSTENOMWST NUMBER > UMBAUKOSTENZUBEHOERBITSNUMBER(19) > ZUORDNUNGBEMERKUNG CLOB > ZUORDNUNGCBXCODE NUMBER(10) > VORGANGSBEMERKUNG CLOB > VORGANGSCBXVARCHAR2(40) > VORGANGSNUMMER VARCHAR2(20) > BESONDERES CLOB > UMBAUKOSTENAUDATEXKALKRAW CLOB > MESSGERAETETYP VARCHAR2(20) > PRGVERSION VARCHAR2(20) > OBDAUSLESEGERAET VARCHAR2(20) > OBDGERAETPRGVERSIONVARCHAR2(20) > > When I issue the below command I am getting ORA-00955 error: > > SQL> alter table feststellung drop column FZALLGEMEINZUSTANDCBXCODE; > alter table feststellung drop column FZALLGEMEINZUSTANDCBXCODE > * > ERROR at line 1: > ORA-00955: name is already used by an existing object > > I observe no locks on the object. Inspite of that it is not allowing > me to > drop the column. Could anybody let me know as to what might be the > reason > for encountering this error and how do I resolve the same? Any help > in this > regard is very much appreciated. > > Thanks and Regards, > > Ranganath > WARNING: The information in this message is confidential and may be > legally > privileged. It is intended solely for the addressee. Access to this > message > by anyone else is unauthorised. If you are not the intended > recipient, any > disclosure, copying, or distribution of the message, or any action or > omission taken by you in reliance on it, is prohibited and may be > unlawful. > Please immediately contact the sender if you have received this > message in > error. Thank you. > -- > Please s
Re: ORA-00955: name is already used by an existing object
GCLOB > FZALLGEMEINZUSTANDCBXCODE NUMBER(10) > NICHTMITBEWERTETETEILE CLOB > EREIGNISCBXVARCHAR2(40) > FAHRER VARCHAR2(20) > FAHRERORT VARCHAR2(30) > FAHRERSTRASSE VARCHAR2(30) > HERGANGSSCHILDERUNGCLOB > HERGANGSSCHILDERUNGLTCBX VARCHAR2(40) > NACHSCHADENANGABENCBX VARCHAR2(40) > NACHSCHADENBEMERKUNG CLOB > POLAUFNAHMEARTCBX VARCHAR2(40) > POLAUFNAHMEARTTEXT VARCHAR2(30) > POLAUFNAHMEDURCH VARCHAR2(30) > SCHADENORT VARCHAR2(30) > SCHADENSTRASSE VARCHAR2(30) > SCHADENUNFALLDATUMCBX VARCHAR2(40) > SCHADENUNFALLDATUMSTR VARCHAR2(10) > SCHADENUNFALLORT VARCHAR2(30) > VORGANGSBEMERKUNGENCLOB > UMBAUKOSTENBEMERKUNG CLOB > UMBAUKOSTENMMWST NUMBER > UMBAUKOSTENOMWST NUMBER > UMBAUKOSTENZUBEHOERBITSNUMBER(19) > ZUORDNUNGBEMERKUNG CLOB > ZUORDNUNGCBXCODE NUMBER(10) > VORGANGSBEMERKUNG CLOB > VORGANGSCBXVARCHAR2(40) > VORGANGSNUMMER VARCHAR2(20) > BESONDERES CLOB > UMBAUKOSTENAUDATEXKALKRAW CLOB > MESSGERAETETYP VARCHAR2(20) > PRGVERSION VARCHAR2(20) > OBDAUSLESEGERAET VARCHAR2(20) > OBDGERAETPRGVERSIONVARCHAR2(20) > > When I issue the below command I am getting ORA-00955 error: > > SQL> alter table feststellung drop column FZALLGEMEINZUSTANDCBXCODE; > alter table feststellung drop column FZALLGEMEINZUSTANDCBXCODE > * > ERROR at line 1: > ORA-00955: name is already used by an existing object > > I observe no locks on the object. Inspite of that it is not allowing > me to > drop the column. Could anybody let me know as to what might be the > reason > for encountering this error and how do I resolve the same? Any help > in this > regard is very much appreciated. > > Thanks and Regards, > > Ranganath > WARNING: The information in this message is confidential and may be > legally > privileged. It is intended solely for the addressee. Access to this > message > by anyone else is unauthorised. If you are not the intended > recipient, any > disclosure, copying, or distribution of the message, or any action or > omission taken by you in reliance on it, is prohibited and may be > unlawful. > Please immediately contact the sender if you have received this > message in > error. Thank you. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Krishnaswamy, Ranganath > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-00955: name is already used by an existing object
VARCHAR2(40) POLAUFNAHMEARTTEXT VARCHAR2(30) POLAUFNAHMEDURCH VARCHAR2(30) SCHADENORT VARCHAR2(30) SCHADENSTRASSE VARCHAR2(30) SCHADENUNFALLDATUMCBX VARCHAR2(40) SCHADENUNFALLDATUMSTR VARCHAR2(10) SCHADENUNFALLORT VARCHAR2(30) VORGANGSBEMERKUNGENCLOB UMBAUKOSTENBEMERKUNG CLOB UMBAUKOSTENMMWST NUMBER UMBAUKOSTENOMWST NUMBER UMBAUKOSTENZUBEHOERBITSNUMBER(19) ZUORDNUNGBEMERKUNG CLOB ZUORDNUNGCBXCODE NUMBER(10) VORGANGSBEMERKUNG CLOB VORGANGSCBXVARCHAR2(40) VORGANGSNUMMER VARCHAR2(20) BESONDERES CLOB UMBAUKOSTENAUDATEXKALKRAW CLOB MESSGERAETETYP VARCHAR2(20) PRGVERSION VARCHAR2(20) OBDAUSLESEGERAET VARCHAR2(20) OBDGERAETPRGVERSIONVARCHAR2(20) When I issue the below command I am getting ORA-00955 error: SQL> alter table feststellung drop column FZALLGEMEINZUSTANDCBXCODE; alter table feststellung drop column FZALLGEMEINZUSTANDCBXCODE * ERROR at line 1: ORA-00955: name is already used by an existing object I observe no locks on the object. Inspite of that it is not allowing me to drop the column. Could anybody let me know as to what might be the reason for encountering this error and how do I resolve the same? Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishnaswamy, Ranganath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
