he is talking about altering the column in the data dictionary. Ive updated TS$ myself and its not that big of a deal.
id be a bit concerned about actually altering a column. Oracle may have some underlying code that you dont know about that assumes a maximum column length = 30 or there is some modelling reason for the limit also. > > From: "Naveen Nahata" <[EMAIL PROTECTED]> > Date: 2003/06/12 Thu AM 08:49:22 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: db file sequential read [WAS:wait event puzzler] > > What?????????????????????? > > > -----Original Message----- > > From: Senthil Kumar D [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 12, 2003 5:05 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: db file sequential read [WAS:wait event puzzler] > > > > > > Dear Bhaskar, > > > > You can modify col$.NAME to varchar2(60) and try. > > > > If this fails, I'll give a procedure you can use that to change it to > > whatever size you want. > > > > Senthil Kumar > > Sr Oracle DBA > > Summitworks Technologies Pvt Ltd > > > > -----Original Message----- > > Bhaskar Viswanathan > > Sent: Thursday, June 12, 2003 4:00 PM > > To: Multiple recipients of list ORACLE-L > > > > > > > > hi, > > > > We use Oracle 8 DB. > > > > I am not a Oracle technical guy. So lemme try explaining the problem. > > > > We need to create tables with columns, whose names(column-names) are > > more than 30 characters long. > > This is being restricted because, all columns of all tables > > have entries > > in a table called 'col'. > > Thit table is defined as: > > > > SQL> desc col > > Name Null? Type > > ----------------------------------------- -------- > > ---------------------------- > > TNAME NOT NULL VARCHAR2(30) > > COLNO NOT NULL NUMBER > > CNAME NOT NULL VARCHAR2(30) > > COLTYPE VARCHAR2(106) > > WIDTH NOT NULL NUMBER > > SCALE NUMBER > > PRECISION NUMBER > > NULLS VARCHAR2(19) > > DEFAULTVAL LONG > > CHARACTER_SET_NAME VARCHAR2(44) > > SQL> > > > > since CNAME is defined as VARCHAR2(30), we are forced to > > retrict column > > names to a max of 30 characters long. > > > > For eg. create table T1(xxxxxxxxxxxxxxxxxxxxxxxxxxxxx31 varchar2(50)); > > The above statement will be rejected with the error: > > * > > ERROR at line 1: > > ORA-00972: identifier is too long > > > > However, the statement "create table T1(xxxxxxxxxxxxxxxxxxxxxxxxxxxx30 > > varchar2(50))" > > Succeeds in creating the table; > > > > I guess this table col is created by the system itself. how can we > > change this size > > So that the 30 character restriction in column names can be avoided??? > > > > baski > > > > **************************Disclaimer************************** > > ********** > > > > Information contained in this E-MAIL being proprietary to > > Wipro Limited is > > 'privileged' and 'confidential' and intended for use only by > > the individual > > or entity to which it is addressed. You are notified that > > any use, copying > > or dissemination of the information contained in the E-MAIL > > in any manner > > whatsoever is strictly prohibited. > > > > ************************************************************** > > ************* > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Bhaskar Viswanathan > > 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). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Senthil Kumar D > > 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). > > > > > DISCLAIMER: > This message (including attachment if any) is confidential and may be privileged. > Before opening attachments please check them for viruses and defects. MindTree > Consulting Private Limited (MindTree) will not be responsible for any viruses or > defects or any forwarded attachments emanating either from within MindTree or > outside. If you have received this message by mistake please notify the sender by > return e-mail and delete this message from your system. Any unauthorized use or > dissemination of this message in whole or in part is strictly prohibited. Please > note that e-mails are susceptible to change and MindTree shall not be liable for any > improper, untimely or incomplete transmission. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Naveen Nahata > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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).
