One of the mains reasons we used views at one place I worked was the "table drop" factor. We never created a table that we didn't immediately create a "select * from ..." view on. We then granted the privileges on the views instead of the tables so that if we ever had to drop and recreate the table all of our grants would stay intact on the view.
Now that you can rebuild the table without dropping it I don't think this approach has much merit but it is something to consider in older databases. Just one more point of view :) --Michael -----Original Message----- Sent: Thursday, February 21, 2002 12:29 PM To: Multiple recipients of list ORACLE-L I like views... right now I'm working on the one out my office window... a spectacular view of the Tobacco Root range across the Gallatin Valley. :-) Regarding database views, you can't say they're entirely good or bad. They may simplify things for reporting but they could complicate your ability to tune the SQL... it just depends. Ad hoc end user queries on a separate non-OLTP reporting server is one thing, ad hoc end user reporting or batch reports with views of production source data on an OLTP server is could be quite another. The idea of having business object views of data and turning end users loose with a reporting tool without DBA supervision can be both appealing and frightening. But duhvelopers SHOULD know what they're doing. ;-) Looking out the window in Bozeman, Montana... Steve Orr -----Original Message----- Sent: Thursday, February 21, 2002 9:18 AM To: Multiple recipients of list ORACLE-L We have several applications that use views extensively. On the other hand there are several apps that use no views at all. We have a new developer who wants to use views when writing reports in Crystal Reports. The application administrator is leery of using views and ask the DBA group what we think. I can see several reasons to use views and a few reasons not to use them. I was just wondering what the rest of the group thought. Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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.com -- Author: Jenkins, Michael - EDS INET: [EMAIL PROTECTED] 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: [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).
