Testing of what? What would be the point of this exercise? I only wish I had that kind of time...
Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Senthil Kumar D [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 12, 2003 10:30 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: db file sequential read [WAS:wait event puzzler] > > > 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: Jesse, Rich 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).