Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g47g2000cwa.googlegroups.com!not-for-mail From: "Peter Nolan" Newsgroups: comp.databases.oracle.server Subject: Re: Reverse Engineering and selecting specific tables Date: 11 Nov 2005 01:47:10 -0800 Organization: http://groups.google.com Lines: 19 Message-ID: <1131702430.550668.76470@g47g2000cwa.googlegroups.com> References: <1130767271.547565.32340@z14g2000cwz.googlegroups.com> <1130775912.047798.180270@g47g2000cwa.googlegroups.com> <1130920051.522125.189020@g43g2000cwa.googlegroups.com> NNTP-Posting-Host: 217.147.100.154 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1131702435 22359 127.0.0.1 (11 Nov 2005 09:47:15 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 11 Nov 2005 09:47:15 +0000 (UTC) In-Reply-To: User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: g47g2000cwa.googlegroups.com; posting-host=217.147.100.154; posting-account=-e5MzQwAAADmHn_JQY8LH93nzIAaEB3T Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:255212 Hi All, Just to complete the discussion..... We had the clients oracle support guys go through metalink and talk with Oracle (the client has 4 oracle apps instances running so they are a reasonably large Oracle client)...... The summary is Oracle say it is ok to use underlying tables. Metalink note number Note:207140.1 says: "The HZ tables will remain in place and will exist in Rel 12. The backward compatible views will be supported in Rel 11.5 however at some point, it is expected that they will be obsoleted and thus unsupported. ... With this in mind, it is strongly recommended that any customizations be based on the HZ tables." Peter www.peternolan.com