Senthil,
This is one of those items that you don't want to do even in R&D. This is
what I call playing Russian Roulette with one chamber empty.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Thursday, June 12, 2003 11:30 AM
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: Goulet, Dick
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).
