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).
Received on Thu Jun 12 2003 - 08:52:20 CDT
