Janet,
A data warehouse is a database. Now if the "data warehouse" has all of the
data structures of the OLTP database and people are using those tables like one would
expect, then your just using the same instance for both purposes, which is a recipe
for disaster in my opinion. A data warehouse is characterized by several large (both
in width and depth) tables with somewhat demoralized and static data and/or a number
of star schemas that have very deep fact tables.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Wednesday, January 07, 2004 12:04 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I have been working with Oracle 92. I have no
experience with Oracle Warehouse. In my current
company, I was told the database is a warehouse. I
can connect to it using sql plus or pl/sql developer.
The "warehouse" looks the same as the database I
worked with before. How do I tell if a database is a
warehouse or just a regular database. What's the big
difference between the two?
Could someone send me some link about data warehouse?
Thank you!
Janet
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Janet Linsy
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
