While this practice would be frowned on, I have had occasion
to do something similar myself.
Developers were required to have the ability to see source
code in stored procedures in production instances through
SQL Navigator, without granting the database privileges that
would normally make this
can't you utilize the comment column?
-Original Message-
Sent: Friday, May 18, 2001 12:26 PM
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
please note you said copies :)
From: Jared Still [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: adding columns to system tables
Date: Mon, 21 May 2001 13:36:23 -0800
While this practice would be frowned on, I have had
It is generally considered bad practice, why not create another table with
the additional columns and just make a view that joins them?
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/18/01 12:25 PM
Does anyone know if it is 'safe' to add additional columns
to
That can't be as bad as re-writing supplied packages :)
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/18/01 1:16 PM
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
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
Absolutely NOT!!! As soon as you do that you are completely unsupported by
Oracle and probably everyone
else.
Rick
-Original Message-
Sent: Friday, May 18, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
Does anyone know if it is 'safe' to add additional columns
to
On Fri, 18 May 2001,Greg Schraiber scribbled on the wall in glitter crayon:
-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
Yes, you CAN add columns to the view as SYS. However, if you break
something doing so, you aren't supported. Also any db upgrades will
destroy your changes and invalidate any code that references it. Better
idea might be to create a table with a similar key as user_tab_columns
with your
Personally i wouldn't do that. How come you couldn't create another table
or a view off of the user_tabl_columns and use that table instead?
Kev
-Original Message-
Schraiber
Sent: Friday, May 18, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
Does anyone know if it is 'safe'
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
11 matches
Mail list logo