| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: db file sequential read [WAS:wait event puzzler]
He is a New commer to the Oracle World and ur telling him to do a Update
on COL$... He Ends up Doing that in his Production Database.. And he is
going to be in a HOT soup....
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
-----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).Received on Thu Jun 12 2003 - 11:02:19 CDT
 |
 |