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: 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).