Very good white papers/technical articles related to DW enhancements/new features in 9i are available on Oracle Technet. They are pretty good. Please take a look at those and see whether you can use those in your DW project.
Hope this helps. Regards YTTRI Lisa <lisa.yttri@c To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> nh.com> cc: Sent by: Subject: 8i or 9i for Data Warehouse root@fatcity. com 10/30/2001 03:05 PM Please respond to ORACLE-L Hi everyone - I have been asked to do the database planning for a fairly large data warehouse. The warehouse is currently in Sybase and is about 160 GB. They are planning to move to Oracle very soon. My questions - does it make more sense to spin it up on 8.1.7 or 9? (This will be a pretty good size Solaris machine). Are there newer features in 9i that would really benefit them? I am looking at partitioning tables and using some bit-mapped indexes - something they don't have today. I was originally looking at 8.1.7, but now that 9 has been around for a little bit, I'm wondering if any of you have some advice (good or bad) regarding version 9. Any and all comments are appreciated. Thanks - lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa 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: 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).