RE: db file sequential read [WAS:wait event puzzler]

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