Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: db file sequential read [WAS:wait event puzzler]

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

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 13 Jun 2003 10:52:12 -0700
Message-ID: <F001.005B183C.20030613103453@fatcity.com>


We should probably clarify this.
1 - has bee

> -----Original Message-----
> From: Bhaskar Viswanathan [mailto:[EMAIL PROTECTED]
> Sent: vendredi, 13. juin 2003 00:29
> To: Multiple recipients of list ORACLE-L
> Subject: RE: db file sequential read [WAS:wait event puzzler]
>
>
>
> Hi,
>
> Thanks to all for you responses.
>
> To sum up the suggestions:
>
> 1) You can modify col$.NAME to varchar2(60) and try......
> 2) 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.(alterning the
> col.Cname size)
> Nothing wrong in this.
> 3) That is a Very Good Idea...
> We will do away with DDL Stmts will start writing directly into
> the Data Dictionary ...
> 4) Oracle does not support column names that are longer than 30
> characters.
> This is a hard standard and can not be changed.
> 5) Ur not supposed to Update Data Dictionaly Tables Directly ...
> Oracle has A Limit of 30 Chrs and is Hardcoded.. So ReName your
> Columns within 30 Chrs...
> 6) Updating a data dictionary is simply not done. Remember, we're
> the DBA (you will be assimilated) and not fun loving students
> who can play with their alma mater's equipment.
> Updating the data dictionary directly would cause the database
> to lose support from
> Oracle Corp. and the perpetrator would be liable.
> 7) 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....
> 8) Write a compress / decompress algorithm that will take your
> 200-character table names from
> the application and pass them to the database as <= 30
> characters; then uncompress them from
> the database back to the application.
> 9) references to DB naming conventions.
>
> I would want to go with the majority. "Do not Do it!!!!!!".
>
> But then, the problem is like, I cannot afford to shorten
> names as there
> are a lot of other problems which crops up.
> Though right now, thatz what we do and which is what I am
> attempting to
> avoid.
> Ofcourse, the suggestion to have an algo. translate the names
> is a good
> one, which is thought of and is the current
> Decision.
>
> Whew!, if oralce supports more than 30 characters for column
> names, life
> would be easier.
>
> Can somebody explain in brief, why this is being restricted to 30
> characters?
>
> And once again, thanks a lot!
>
> Baski
>
> -----Original Message-----
> 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).
>
> **************************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: Jacques Kilchoer
  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 Fri Jun 13 2003 - 12:52:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US