From cspence@FuelSpot.com Sat, 19 May 2001 21:50:22 -0700 From: Christopher Spence Date: Sat, 19 May 2001 21:50:22 -0700 Subject: RE: adding columns to system tables Message-ID: MIME-Version: 1.0 Content-Type: text/plain I don't think there is many select *, generally most people (as well as oracle currently) name all the columns. Even without doing this, unless your doing something wierd, ussually the columns are not touched, although I would not recommend making this change and would infact use a joined view. -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 5/18/01 1:41 PM Just think of the internal code that uses SELECT * from USER_TAB_COLUMNS; after you add a column. || -----Original Message----- || From: Jack C. Applewhite [mailto:japplewhite@inetprofit.com] || Sent: Friday, May 18, 2001 1:17 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: adding columns to system tables || || || Greg, || || It is 'safe' in that you won't die or get injured. However, || your database || may and your support from Oracle certainly will. || || "Don't even think about it." || || Jack || || -------------------------------- || Jack C. Applewhite || Database Administrator/Developer || OCP Oracle8 DBA || iNetProfit, Inc. || Austin, Texas || www.iNetProfit.com || japplewhite@inetprofit.com || (512)327-9068 || || || -----Original Message----- || Schraiber || Sent: Friday, May 18, 2001 11:26 AM || To: Multiple recipients of list ORACLE-L || || || Does anyone know if it is 'safe' to add additional columns || to user_tab_columns? I am running 8.1.5. I would use the new || columns to tell the application software which columns on || any one table are user editable by a dynamically generated || dialog form. || || Thanks, || Greg || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Greg Schraiber || INET: GregSchraiber@Finestri.Com || || Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California -- Public Internet access / || Mailing Lists || -------------------------------------------------------------------- || To REMOVE yourself from this mailing list, send an E-Mail message || to: ListGuru@fatcity.com (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.com || -- || Author: Jack C. Applewhite || INET: japplewhite@inetprofit.com || || Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California -- Public Internet access / || Mailing Lists || -------------------------------------------------------------------- || To REMOVE yourself from this mailing list, send an E-Mail message || to: ListGuru@fatcity.com (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.com -- Author: Mohan, Ross INET: MohanR@STARS-SMI.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (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.com -- Author: Christopher Spence INET: cspence@FuelSpot.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (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).