Oracle
in [SQL]
|
Materialized Views and Paritions in fact tables Hi, I have a situation where I have a materialized view/log to refresh on commit on a fact table that is subject to archive considerations. The fact table is partitioned by date range. Now, the materialized view has very few rows and therefore not partitioned. My question is, if older partitions in the fact t... 29 Dec 2009 11:53
oracle and database ebooks I am searching for the best ebooks for : 1-database systems 2-oracle 11 sql/pl 3-oracle 11 developer Please recommend them for me . Also I need to know the codes of those oracle tests : oracle 11 developer , oracle 11 sql/pl. Thanks in advance for your help. Thanks ... 6 Jan 2010 08:28
Global Warming and what you can do to against it Dear All, As you know global warming is endangering the future of life on the planet. It will also affect us; rising sea levels, dwindling water supplies, mass deaths due to heat waves, stoppage of the gulfstream, which brings milder climate to north of Europe, super hurricanes, less food due to droughts are some... 27 Dec 2009 10:50
DBA_TAB_STATISTICS.AVG_CACHED_BLOCKS, AVG_CACHE_HIT_RATIO Hi All, In 10g Oracle introduced view DBA_TAB_STATISTICS. Many columns are identical to those available in DBA_TABLE (NUM_ROWS, LAST_ANALYZED), but there are new columns, in particular: - AVG_CACHED_BLOCKS - AVG_CACHE_HIT_RATIO I checked a few databases and these columns don't get populated. It should be po... 27 Dec 2009 21:46
Make Money From Home - How to Deal With Distractions Life is full of distractions, interruptions, unexpected challenges and needs. With the arrival of the cell phone, these distractions have tripled. Nowadays you are constantly reachable unless you take definite steps to control your phone and your time. Now that you are working from home, http://i-affil... 25 Dec 2009 03:59
Oracle 11g r2 one node RAC I have read Oracles documentation on this new feature is 11gr2, but not clear what exactly it does? http://www.oracle.com/technology/products/database/clustering/pdf/ug_raconenode-2009.pdf 1. Can I have multiple instances of same database on same node of RAC. In absence of one node RAC, I will have one instance ... 2 Jan 2010 02:03
Looks like 11.2 now available on hpux and aix Windows release still dragging behind ... that is a change in behavior from last couple of releases. ( Not that we run any oracle databases on windows where I play ). HPUX is Itanium only apparently so far. ... 23 Dec 2009 13:37
min(); never no_data_found How can you make min() throw no_data_found? select min(datex) from tablex where x = 1; With min(), I never get a no_data_found exception. ... 27 Dec 2009 19:35
min(); never no_data_found On 22.12.2009 21:39, cate wrote: On Dec 22, 2:37 pm, cate<catebekens...(a)yahoo.com> wrote: How can you make min() throw no_data_found? select min(datex) from tablex where x = 1; With min(), I never get a no_data_found exception. The check is useless because the IF condition is tested only w... 23 Dec 2009 10:49
there is an error in comments On Dec 21, 7:45 am, Daneel Yaitskov <rtfm.rtfm.r...(a)gmail.com> wrote: snip Hi List, I use Oracle 10 XE. I'm a student. When I wrote my lab then I had found that Oracle alerts about an error for the line: call echo('dddddd'); -- comment But it processes normally this line without the comment... 13 Jan 2010 04:20 |