As an IT Manager you may be thinking of acquiring a data warehouse to develop insights for your business. You are presented with a number of options like installing it in your own data center, using a cloud service or even purchasing a hardware/appliance ready for this purpose. This is a quick guide to help you compare certain options. The article will not describe any specific product.
Have you gotten an ORA-00942 error? I’ll explain the cause and the solution of the error in this article. ORA-00942 Cause The error message appears when you try to run an SQL statement: ORA-00942: table or view does not exist This happens for one of many reasons: The statement references a table or view that […]
This week I’ve read a few interesting articles on Oracle and I thought I’d share them here. RI (Referential Integrity) Constraints: 3 Reasons to Include Them in Your Data Warehouse Kent Graziano from The Data Warrior (and Snowflake) wrote an interesting article on using referential integrity constraints inside a data warehouse. I haven’t really considered […]
Did you get an “ORA-00904: invalid identifier” error? Find out what caused the ORA-00904 error and how to resolve it in this article. ORA-00904 Cause So, you ran an SQL statement and you got this error: ORA-00904: invalid identifier What causes this error? It’s caused by referring to a column that does not exist, or […]
If you like the look of the new Index Advanced Compression setting of “High” available with Oracle Database 12c Release 2 as I’ve discussed previously in Part I and Part II, well there’s a way to make this the default index compression method in your 12.2 database. Let’s begin by creating a table and explicitly […]