Well, I didn't see you say "do this in a test database only." in your first e-mail, so he goes and do it in the production database.
In general, people on this list made sure advises like this comes with a warning such as "this is not supported by Oracle, therefore, do it at your own risk. Make sure test it in your test environment first.". Richard -----Original Message----- Senthil Kumar D Sent: Thursday, June 12, 2003 11:30 PM To: Multiple recipients of list ORACLE-L I do agree with you. But some times we may need go beyond the scopes. For testing purpose we can do these kind of R&D's. Nothing wrong in this. Senthil. -----Original Message----- CP Sent: Thursday, June 12, 2003 7:10 PM To: Multiple recipients of list ORACLE-L Modifying data dictionary tables is definitely not a good idea and I am sure Oracle will not support this. CP [EMAIL PROTECTED] wrote: >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). > > > -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with [EMAIL PROTECTED] http://shopnow.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CP 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ganesh Raja 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: Richard Ji 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).
