ed

I've moved the blog!

By nancythroughthelookingglass.blogspot.com
Published On :: Fri, 18 Jul 2014 03:47:00 +0000

You can find all my old articles and new posts here

http://nancyscrazyadventures.wordpress.com/

Goodbye google


Full Article

ed

Ijsgang verhinderd uitvaren reddingsboot Ameland

By www.ameland.org
Published On :: 31-12-2008 12:52:37

Door de ijsgang kan de reddingsboot, van het planerende type, van Ameland niet uitvaren


Full Article

ed

Bolufer et son pied-à-terre

By poypoye.over-blog.com
Published On :: Thu, 20 Dec 2007 15:13:18 +0100

Le directeur de cabinet de Christine Boutin, actuelle ministre du Logement, loue depuis 1981 un appartement à loyer modéré propriété de la RIVP (la régie immobilière de la ville de Paris). Selon le Canard enchaîné, qui révèle l’information, Jean-Paul...


Full Article

ed

LVC-Audio - Limited-Z 1.1.0

By www.dontcrack.com
Published On :: Sat, 12 Aug 2017 08:14:34 +0100

Freeware for PC : Plug-ins & effects / Limiter


Full Article

ed

Vijesti :: Potpisan sporazum o suradnji između Akademije za umjetnost i kulturu u Osijeku i Hrvatske komore dentalne medicine

By www.osijek031.com
Published On :: Tue, 12 Nov 2024 10:59:00 GMT

Autor: Redakcija 031 Naslov: Potpisan sporazum o suradnji između Akademije za umjetnost i kulturu u Osijeku i Hrvatske komore den
Postano: 12.11.2024. 11:59 (GMT 1) Dana 11. studenog 2024., točno u 11 sati i 11 minuta, u Svečanoj dvorani Akademije za umjetnost i kulturu u Osijeku potpisan je sporazum o suradnji između Akademije i Hrvatske komore dentalne medicine. Sporazum su uime institucija potpisali dekanica Akademije, akademkinja Helena Sablić Tomić, i dr. sc. Hrvoje Pezo, predsjednik Komore.

Sporazum označava početak suradnje između jedinstvene umjetničko-znanstvene institucije u zemlji i strukovne organizacije koja predstavlja dentalnu medicinu u Hrvatskoj. Cilj je sporazuma objediniti znanje i resurse kako bi se postigli viši standardi u razumijevanju i unaprjeđenju zajedničkih područja djelovanja koji se protežu kroz edukaciju, zdravstvo, kulturu i interdisciplinarne projekte koji se razvijaju na specijalističkom studiju Kreativnih terapija pri Akademiji za umjetnost i kulturu u Osijeku.

„Ovim partnerstvom želimo otvoriti nove mogućnosti suradnje u području obrazovanja i profesionalnog razvoja te omogućiti razmjenu iskustava između umjetničko-znanstvene zajednice i medicinske struke“, istaknula je akademkinja Helena Sablić Tomić. „Akademija i Komora mogu se zajedničkim naporima baviti istraživanjem novih pristupa u edukaciji kao i poticanjem šireg društvenog dijaloga o važnosti holističkog pristupa zdravlju.“

Predsjednik Komore dr. sc. Hrvoje Pezo naglasio je da sporazum predstavlja jedinstvenu priliku za razvoj novih standarda u edukaciji o zdravstvenoj kulturi i prevenciji. „Spoj umjetničkog i znanstvenog pristupa, uz medicinsku ekspertizu, omogućuje nam da dublje sagledamo utjecaj koji zdravlje ima na svakodnevni život, ali i na kulturu i društvenu dinamiku. Vjerujemo da će se kroz ovu suradnju razvijati inovativni pristupi obrazovanju i informiranju javnosti,“ izjavio je dr. Pezo.


Tekst i foto: Akademija za umjetnost i kulturu u Osijeku


Full Article

ed

Vijesti :: 15 brončanih, 9 srebrnih i 6 zlatnih medalja za Dizački klub Slavonija

By www.osijek031.com
Published On :: Tue, 12 Nov 2024 15:53:36 GMT

Autor: Redakcija 031 Naslov: 15 brončanih, 9 srebrnih i 6 zlatnih medalja za Dizački klub Slavonija
Postano: 12.11.2024. 16:53 (GMT 1)
Proteklog vikenda održano je Prvenstvo Hrvatske za žene i muškarce U-23 u Vukovaru. Dizački klub Slavonija predstavljali su 12 natjecatelja i natjecateljica.

- Stipe Živalj (kategorija do 61 kg) – 3. mjesto u trzaju, izbačaju i biatlonu
- Urban Dergez (kategorija do 73 kg) – 3. mjesto u trzaju, izbačaju i biatlonu
- Teo Krišto (kategorija do 81 kg) – 3. mjesto u trzaju, izbačaju i biatlonu
- Tin Krišto (kategorija do 81 kg) – 2. mjesto u trzaju, izbačaju i biatlonu
- Leo Štivić (kategorija do 89 kg) – 8. mjesto u trzaju, izbačaju i biatlonu
- Ivan Gazdić (kategorija do 89 kg) – 5. mjesto u trzaju, izbačaju i biatlonu
- Sven Kroflin (kategorija do 96 kg) – 1.mjesto u trzaju, izbačaju i biatlonu
- Ema Štivić (kategorija do 64 kg) – 3. mjesto u trzaju, izbačaju i biatlonu•
- Željka Milković (kategorija do 71 kg) – 3. mjesto u trzaju, izbačaju i biatlonu
- Blanka Jurić (kategorija do 76 kg) – 2. mjesto u trzaju, izbačaju i biatlonu
- Anastasija Sarkić (kategorija do 81 kg) – 2. mjesto u trzaju, izbačaju i biatlonu
- Luna Varga (kategorija +87 kg) – 1. mjesto u trzaju, izbačaju i biatlonu

Ovime je Dizački klub Slavonija kući nosio 15 brončanih, 9 srebrnih i 6 zlatnih medalja. Osim pojedinačnog poretka, mogu se pohvaliti i ekipnim. Žene su odnijele 2. mjesto u ekipnom poretku, a muški 1. mjesto.

Čestitamo svim natjecateljima, posebno našim članovima. Neka nastave trenirati kao i dosad, predano i disciplinirano i rezultati će se pokazati sami, kažu iz kluba.



Tekst i foto: DK Slavonija


Full Article

ed

Događaji - najave i recenzije :: Centar za kulturu Čepin: Stand-up comedy show "Ja sam ti takav"

By www.osijek031.com
Published On :: Wed, 13 Nov 2024 07:14:56 GMT

Autor: Redakcija 031 Naslov: Centar za kulturu Čepin: Stand-up comedy show "Ja sam ti takav"
Postano: 13.11.2024. 8:14 (GMT 1) Tomislav Primorac, poznati stand-up komičar i predstavnik SplickeScene, sa showom „Ja sam ti takav“ stiže u Centar za kulturu Čepin. Nastupit će u petak, 15. studenog 2024. u 20 sati.

O komičaru Tomislavu Primorcu
Ovaj stand-up komičar prepoznatljiv je po svom britkom humoru i specifičnom stilu. Opisuje se kao „poludalmatinac“ i „poluhercegovac“ te kao mitološko biće kojeg se boje svi Purgeri. Iako je diplomirani fizičar, odlučio je krenuti putem komedije, što je izazvalo razočaranje njegovih roditelja. Njegov je životni san da bude zapamćen poput Nikole Tesle – ali ne iz altruističnih razloga, već da bi se Dalmatinci i Hercegovci svađali na temu čiji je.

Njegov humor balansira između svakodnevnih situacija i dubljih promišljanja o životu. Cilj mu je pronaći ga u onome što svi proživljavaju. Publiku svih uzrasta - od studenata do sredovječnih muškaraca i baka - uspijeva nasmijati svojom domišljatošću i logikom.

O showu „Ja sam ti takav“
Show „Ja sam ti takav“ dinamičan je i emotivno duboko uronjen u svakodnevni život. Primorac koristi humor kako bi razotkrio obiteljske odnose, kulturne razlike i jezične analize, pri čemu se obraća svima - bez obzira na dob ili društveni status. Ovaj show pruža priliku za smijeh i razmišljanje o životu kroz komične, ali istinite situacije.

„Ne propustite priliku za uživanje u ovom jedinstvenom stand-up iskustvu u Čepinu. Garantiramo večer prepunu smijeha i dobre energije“, poručili su Arlekin Comedyja, organizatora ovog događanja.

Kako do ulaznica?
Ulaznice se prodaju po cijeni od 10 eura. Mogu se kupiti online u sustavima Core event i Adriaticket. Fizička prodaja vrši se na lokacijama: caffe bar Onyx, TISAK+ (Gacka ulica 10), TISAK Media Portanova (uz dodatni trošak od 1 eura). Rezervacije su moguće pozivom na broj 098 977 25 41 (Arlekin Comedy), na kojem je moguće dobiti i dodatne informacije.


Full Article

ed

Događaji - najave i recenzije :: GISKO: Predstavljanje knjige "Ironwoman: moja priča"

By www.osijek031.com
Published On :: Wed, 13 Nov 2024 08:50:40 GMT

Autor: Redakcija 031 Naslov: GISKO: Predstavljanje knjige "Ironwoman: moja priča"
Postano: 13.11.2024. 9:50 (GMT 1) Gradska i sveučilišna knjižnica Osijek organizira predstavljanje knjige pod nazivom “Ironwoman: moja priča!” autorice Đurđice Orepić.

Predstavljanje će se održati u četvrtak, 21. studenog 2024. s početkom u 17.00 sati u prostoru Studijske čitaonice Gradske i sveučilišne knjižnice Osijek. Program će moderirati Saša Drinić i Željko Garmaz.

Ironwoman: moja priča knjiga je o ženi koja je, kako navodi urednica knjige Korana Svilar, “životu u inat i životu za ljubav odlučila da neće više samo ‘hodati’, nego trčati, plivati i pedalirati stotinama kilometara – ona će se natjecati u triatlonu, jer život se živi, a ne preživljava”. Iznenađujući sve koji svjedoče njezinoj odluci da pomiče vlastite granice, trpjet će bol i previranja, plakat će i smijati se, upoznat će vlastito tijelo u najekstremnijim uvjetima, prkosit će sebi i svima koji sumnjaju i natjecati se u Ironmanu, najtežoj utrci na svijetu. Ništa nije nemoguće onome tko ima volju pobijediti samoga sebe, dokazuje Đurđica Orepić, najbolja svjetska Ironwoman u svojoj dobnoj skupini.

U memoarskoj prozi Ironwoman: moja priča Đurđica Orepić nadahnuto ispisuje svoje nevjerojatno iskustvo, ne štedeći ni srce ni smisao za humor. I jedinstvena Đu pobjeđuje još jednom. No, ovoga puta ne osvaja trofeje, već srca čitatelja, kojima svakom stranicom prenosi svoju najveću strast – život sâm. U osvrtu na knjigu, Boris Dežulović je napisao da knjiga Ironwoman: moja priča „nije samo priča o uspješnoj ženi koja nikad u životu nije obula patike, pa u pedesetoj odluči postati svjetska prvakinja u triatlonu, ovo je i priča o uspješnoj ženi iza koje – kao iza svake uspješne i dovršene žene – stoji muškarac“.


Full Article

ed

Vijesti :: Reprezentativci iz redova Nogometnog kluba Osijek ponovno u akciji

By www.osijek031.com
Published On :: Wed, 13 Nov 2024 09:15:00 GMT

Autor: Redakcija 031 Naslov: Reprezentativci iz redova Nogometnog kluba Osijek ponovno u akciji
Postano: 13.11.2024. 10:15 (GMT 1) Reprezentativci iz redova Nogometnog kluba Osijek opet su u akciji. U A selekciju Bosne i Hercegovine ponovno je pozvan Nail Omerović koji je nedavno debitirao protiv Mađarske u Ligi nacija. Sada je ostao u konkurenciji za predstojeće dvoboje u istome natjecanju, protiv Njemačke (16. studenoga) u Freiburgu i Nizozemske tri dana kasnije u Zenici. Sergej Barbarez ga također vidi na poziciji desnog bočnog, na kojoj najčešće igra i u redovima Bijelo-plavih. Arnel Jakupović ostao je i nadalje na širem popisu reprezentativaca Austrije za utakmice protiv Kazahstana i Slovenije. „Na oku“ je, dakle, izborniku Ralfu Rangnicku koji prati njegove igre za NK Osijek, što mu je zasigurno motiv više da se kod nas pokaže u najboljem izdanju.

Mlada reprezentacija u play-offu s Gruzijcima
Ovaj puta imamo trojicu igrača koji su dobili pozive za U-21 selekciju Hrvatske. To su Nikola Čavlina, Marko Soldo i Ivan Cvijanović, za koje možemo reći da su standardni u ovoj selekciji, dok su na pretpozivu ostali Domagoj Bukvić i Šimun Mikolčić. Izabranike Ivice Olića očekuju dva izlučna susreta play-offa na kraju kvalifikacija za Europsko prvenstvo i to protiv Gruzije. Prvo će se igrati 15. studenoga u Tbilisiju, a 19.11. uzvrat je na riječkoj Rujevici. Niko Farkaš i Filip Živković iznova su uvršteni u reprezentaciju U-19 koja svoje kvalifikacije za plasman na kontinentalnu smotru nastavlja turnirom u Karlovcu. Od 13. do 19. studenoga Hrvatska će redom igrati protiv Armenije, Bjelorusije i Srbije. Imamo i dvojicu U-18 reprezentativaca. To su Fran Peček i Ivan Barić, također naši juniori koji putuju u Rijeku na prijateljski turnir gdje će naša nacionalna vrsta za protivnike imati vršnjake iz Portugala, Republike Irske i Japana. I za kraj, Matej Grahovac i Dražen Jaman uvršteni su u selekciju U-17 za dvije kontrolne utakmice s Ukrajinom, također u Rijeci.


Tekst: NK Osijek
Foto: Igor Miličić/Arhiv


Full Article

ed

Vijesti :: Lovro Nedeljković osmi na Balkanu

By www.osijek031.com
Published On :: Wed, 13 Nov 2024 10:05:00 GMT

Autor: Redakcija 031 Naslov: Lovro Nedeljković osmi na Balkanu
Postano: 13.11.2024. 11:05 (GMT 1) U rumunjskom gradu Campulung Moldovenescu održano je prvenstvo Balkana u krosu.

Konkurencija je bila vrlo jaka, a u sastavu hrvatske reprezentacije našao se i član AK Slavonija-Žito Lovro Nedeljković. U utrci seniora na 10.000 metara naš je dugoprugaš zauzeo vrlo dobro, osmo mjesto s rezultatom 31:59,33.

Zlato je osvojio Albanac David Nikolli s vremenom 30:24,61, srebro je zaslužio Turčin Ayetullah Aslanhan (30:32,31), dok je bronca pripala Ukrajincu Ihoru Porozovu (30:44,86).

Nedeljković je, inače, ostvario najbolji plasman od hrvatskih reprezentativaca koji su nastupili u ovoj konkurenciji.


Tekst i foto: AK Slavonija-Žito


Full Article

ed

Događaji - najave i recenzije :: Predstavljanje knjiga "Suvremeni hrvatski haiku - Nova antologija" i "Dosje i druge priče"

By www.osijek031.com
Published On :: Wed, 13 Nov 2024 13:09:37 GMT

Autor: knjizaraNOVA Naslov: Predstavljanje knjiga "Suvremeni hrvatski haiku - Nova antologija" i "Dosje i druge p
Postano: 13.11.2024. 14:09 (GMT 1) Društvo hrvatskih književnika i Klub knjižare Nova pozivaju Vas na predstavljanje knjiga "Suvremeni hrvatski haiku - Nova antologija" i "Dosje i druge priče".

Na predstavljanju sudjeluju: Nikola Đuretić, Tomislav Maretić i Mirko Ćurić.

Predstavljanje će se održati u Klubu knjižare Nova (Trg Ante Starčevića 4, Osijek) u subotu, 16. studenoga u 11 sati.

Radujemo se Vašem dolasku!


Full Article

ed

Vijesti :: Grb grada Malog Lošinja dvojici pripadnika Jedinice specijalne i interventne policije Osijek

By www.osijek031.com
Published On :: Wed, 13 Nov 2024 15:00:00 GMT

Autor: Redakcija 031 Naslov: Grb grada Malog Lošinja dvojici pripadnika Jedinice specijalne i interventne policije Osijek
Postano: 13.11.2024. 16:00 (GMT 1) Povodom Dana Grada Malog Lošinja dodijeljen je Grb Grada i dvojici pripadnika Jedinice specijalne i interventne policije Osijek, za izuzetnu hrabrost, stručnost i profesionalnost u realizaciji složene akcije izmještanja mine iz lošinjskog akvatorija 14. ožujka ove godine.

Robert Dorinka i Tomislav Slabinac su ronioci Jedinice specijalne i interventne policije Osijek, koji su sudjelovali u izmještanju mine zaostale iz 2. svjetskog rata, koja se nalazila u lošinjskom akvatoriju.

Da se radilo o opasnom podvigu, potvrđuje činjenica da je zbog bombe teške oko 1000 kilograma, uoči početka akcije zbog mjera sigurnosti u potpunosti evakuirano stanovništvo iz takozvane crvene zone, odnosno područja uvale Čikat. Osim toga je tijekom akcije bila na snazi privremena zabrana cestovnog, pomorskog i zračnog prometa.


Tekst i foto: PU osječko-baranjska


Full Article

ed

Hostname/IP Address Resolution Utility Released

By www.ensode.net
Published On ::

A new utility that resolves an IP address from a given hostname (and vice versa) has just been released.


Full Article

ed

Excel Spreadsheet Unlocking Utility Released

By www.ensode.net
Published On ::

Sometimes Excel spreadsheets contain locked sheets that cannot be updated without entering a password. This free online utility removes the password protection from any Excel spreadsheet.


Full Article

ed

Guide To Installing Fedora Core 6 On HP Pavilion dv2000 Series Laptops

By www.ensode.net
Published On ::

This guide provides installation and configuration instructions for installing Fedora Core 6 on HP Pavilion dv2000 series laptops.


Full Article

ed

A Java Developer's Review of Fedora 8

By www.ensode.net
Published On ::

The latest version of the Fedora Linux Distribution includes a completely open source Java compiler and JVM called IcedTea, in addition to several Java tools and libraries. We took Fedora 8's tools for a spin and reported our findings in this article.


Full Article

ed

YouTube's Top Rated!

By www.blog-bloke.com
Published On :: Wed, 30 Aug 2006 23:49:00 -0700


More links: blog bloke, instabloke, blog, weblog, blogging, blog tools, blogtech, webtech, web 2.0, blog search, blog resources, diary, writing, write,

computing, internet, computers and internet, technology, tech, software, hardware,

search engine, google,

music, audio, ipod, podcasting, podcast, video, media,

business, marketing,

daily fisk, political football, news, world news, us-news, in the news, news headlines, headline news,

news and politics, politics, political,

current events, current affairs,

opinion, rant, ramblings, random thoughts,

terror, terrorism, terrorist, london bombing,

society, law, legal, dispute resolution,
,
music, entertainment,

fun, funny humor, humour,

canada, canadian, canadian news, canadian-news, canada news, canada-news, canadian politics, canadian-politics


Full Article

ed

Reddit! What's Popular Online 24/7

By www.blog-bloke.com
Published On :: Thu, 31 Aug 2006 22:57:00 -0700

More links: blog bloke, instabloke, blog, weblog, blogging, blog tools, blogtech, webtech, web 2.0, blog search, blog resources, diary, writing, write, computing, internet, computers and internet, technology, tech, software, hardware, search engine, google, music, audio, ipod, podcasting, podcast, video, media, business, marketing, daily fisk, political football, news, world news, us-news, in the news, news headlines, headline news, news and politics, politics, political, current events, current affairs, opinion, rant, ramblings, random thoughts, terror, terrorism, terrorist, london bombing, society, law, legal, dispute resolution,
music, entertainment, fun, funny humor, humour, canada, canadian, canadian news, canadian-news, canada news, canada-news, canadian politics, canadian-politics


Full Article

ed

It's Official - Blog Bloke has moved

By www.blog-bloke.com
Published On :: Fri, 4 Jan 2008 13:01:00 -0800

Hi Blokesters. It's official now and InstaBloke has moved over to Blog Bloke dot com, so please make a note of it and update your bookmarks as well as the newsfeed. You should also check out my latest post explaining all of the gory details. It's a doozy.

See you there!


Full Article

ed

Bitemojo self-guided foodtours: een review

By wielrennen.blog.nl
Published On :: Mon, 26 Feb 2018 17:47:19 +0000

BARCELONA – Het is goed uitkijken in het drukke Barcelona. Bitemojo heeft wielrennen.blog.nl een self-guided food tour aangeboden die wij ...... Lees verder: Bitemojo self-guided foodtours: een review


Full Article

ed

Forum RSS Feeds

By www.wehlou.com
Published On :: Wed, 21 Apr 2004 23:58:14 +0200

I've added RSS Feeds to both my fora. These allow you to instantly see new posts in any public forum, including both subject and full body text. Things are only getting cooler.


Full Article

ed

Are older releases of the database really unsupported?

By www.orafaq.com
Published On :: Sun, 28 Jul 2013 10:19:47 +0000

articles: 
RDBMS Server

I see posts on Oracle related forums about various releases (anything that isn't 11.x or 12.x) being "unsupported". This is wrong. Of course you should upgrade any 9i or 10g databases, but you don't have to.

Oracle Corporation's lifetime support policy is documented here,
Lifetime Support Policy
take a look, and you'll see that release 10.2 was in premier support until end July 2010 when it went into extended support. At end July 2013, it goes into sustaining support. Sustaining support will continue indefinitely. Even release 8.1.7 will have sustaining support indefinitely.
So what is sustaining support? That is documented here,
Lifetime support benefits
To summarize, extended support gives you everything you are likely to need. What you do not get is certification against new Oracle products or new third party products (principally, operating systems). But does that matter? I don't think so. For example, release 11.2.0.3 (still in premier support) is not certified against Windows 8, but it works fine.
Sustaining support has a more significant problem: no more patches. Not even patches for security holes, or changes in regulatory requirements. The security patch issue may of course be serious, but regulatory issues are unlikely to matter (this is a database, not a tax management system.) Think about it: 10g has been around for many years. It is pretty well de-bugged by now. If you hit a problem with no work around, you are pretty unlucky. Sustaining support gives you access to technical support, available patches, software, and documentation. That is all most sites will ever need.
Right now, I am working on a 9.2.0.8 database. It cannot be upgraded because the application software is written by a company that does not permit a database upgrade. Why not? Well, the reason may be commercial: they have a replacement product that is supported on newer databases. But that is nothing to do with me. The database works, the software works. Making it work better is a challenge - but that is what a DBA is paid to do. Don't just write it off as "unsupported".
Of course I am not suggesting that users should not upgrade to current releases - but upgrades are a huge project, and can have major implications. Running out dated software is silly, unless you have an irrefutable reason for so doing. The lack of security patches make you vulnerable to data loss. The lack of regulatory patches may make it illegal. The lack of newer facilities will be restricting the utility of the system. You may be losing money by not taking of advantage of changes of newer technology that can better exploit your hardware.
If anyone is looking for consulting support to upgrade their database - my boss will be happy to give you a quote. But I won't refuse to support you in the meantime.
--
John Watson
Oracle Certified Master DBA
http://skillbuilders.com


Full Article

ed

Three impossibilities with partitioned indexes

By www.orafaq.com
Published On :: Sun, 01 Sep 2013 16:22:11 +0000

articles: 
RDBMS Server

There are three restrictions on indexing and partitioning: a unique index cannot be local non-prefixed; a global non-prefixed index is not possible; a bitmap index cannot be global. Why these limitations? I suspect that they are there to prevent us from doing something idiotic.

This is the table used for all examples that follow:

CREATE TABLE EMP
      (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,
       ENAME VARCHAR2(10),
       JOB VARCHAR2(9),
       MGR NUMBER(4),
       HIREDATE DATE,
       SAL NUMBER(7,2),
       COMM NUMBER(7,2),
       DEPTNO NUMBER(2) )
PARTITION BY HASH (EMPNO) PARTITIONS 4;

the usual EMP table, with a partitioning clause appended. It is of course a contrived example. Perhaps I am recruiting so many employees concurrently that a non-partitioned table has problems with buffer contention that can be solved only with hash partitioning.

Why can't I have a local non-prefixed unique index?
A local non-unique index is no problem, but unique is not possible:

orclz> create index enamei on emp(ename) local;

Index created.

orclz> drop index enamei;

Index dropped.

orclz> create unique index enamei on emp(ename) local;
create unique index enamei on emp(ename) local
                              *
ERROR at line 1:
ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index

You cannot get a around the problem by separating the index from the constraint (which is always good practice):

orclz> create index enamei on emp(ename) local;

Index created.

orclz> alter table emp add constraint euk unique (ename);
alter table emp add constraint euk unique (ename)
*
ERROR at line 1:
ORA-01408: such column list already indexed


orclz>

So what is the issue? Clearly it is not a technical limitation. But if it were possible, consder the implications for performance. When inserting a row, a unique index (or a non-unique index enforcing a unique constraint) must be searched to see if the key value already exists. For my little four partition table, that would mean four index searches: one of each local index partition. Well, OK. But what if the table were range partitioned into a thousand partitions? Then every insert would have to make a thousand index lookups. This would be unbelievably slow. By restricting unique indexes to global or local prefixed, Uncle Oracle is ensuring that we cannot create such an awful situation.

Why can't I have a global non-prefixed index?
Well, why would you want one? In my example, perhaps you want a global index on deptno, partitioned by mgr. But you can't do it:

orclz> create index deptnoi on emp(deptno) global partition by hash(mgr) partitions 4;
create index deptnoi on emp(deptno) global partition by hash(mgr) partitions 4
                                                                *
ERROR at line 1:
ORA-14038: GLOBAL partitioned index must be prefixed


orclz>
This index, if it were possible, might assist a query with an equality predicate on mgr and a range predicate on deptno: prune off all the non-relevant mgr partitions, then a range scan. But exactly the same effect would be achieved by using global nonpartitioned concatenated index on mgr and deptno. If the query had only deptno in the predicate, it woud have to search each partition of the putative global partitioned index, a process which would be just about identical to a skip scan of the nonpartitioned index. And of course the concatenated index could be globally partitioned - on mgr. So there you have it: a global non-prefixed index would give you nothing that is not available in other ways.

Why can't I have a global partitioned bitmap index?
This came up on the Oracle forums recently, https://forums.oracle.com/thread/2575623
Global indexes must be prefixed. Bearing that in mind, the question needs to be re-phrased: why would anyone ever want a prefixed partitioned bitmap index? Something like this:

orclz>
orclz> create bitmap index bmi on emp(deptno) global partition by hash(deptno) partitions 4;
create bitmap index bmi on emp(deptno) global partition by hash(deptno) partitions 4
                                       *
ERROR at line 1:
ORA-25113: GLOBAL may not be used with a bitmap index

orclz>

If this were possible, what would it give you? Nothing. You would not get the usual benefit of reducing contention for concurrent inserts, because of the need to lock entire blocks of a bitmap index (and therefore ranges of rows) when doing DML. Range partitioning a bitmap index would be ludicrous, because of the need to use equality predicates to get real value from bitmaps. Even with hash partitions, you would not get any benefit from partition pruning, because using equality predicates on a bitmap index in effect prunes the index already: that is what a bitmap index is for. So it seems to me that a globally partitioned bitmap index would deliver no benefit, while adding complexity and problems of index maintenance. So I suspect that, once again, Uncle Oracle is protecting us from ourselves.

Is there a technology limitation?
I am of course open to correction, but I cannot see a technology limitation that enforces any of these three impossibilities. I'm sure they are all technically possible. But Oracle has decided that, for our own good, they will never be implemented.
--
John Watson
Oracle Certified Master DBA
http://skillbuilders.com


Full Article

ed

Inverted tables: an alternative to relational structures

By www.orafaq.com
Published On :: Sun, 08 Sep 2013 08:52:30 +0000

articles: 
Warehousing

The inverted table format can deliver fast and flexible query capabilities, but is not widely used. ADABAS is probably the most successful implementation, but how often do you see that nowadays? Following is a description of how to implement inverted structures within a relational database. All code run on Oracle Database 12c, release 12.1.0.1.

Consider this table and a few rows, that describe the contents of my larder:

create table food(id number,capacity varchar2(10),container varchar2(10),item varchar2(10));
insert into food values(1,'large','bag','potatoes');
insert into food values(2,'small','box','carrots');
insert into food values(3,'medium','tin','peas');
insert into food values(4,'large','box','potatoes');
insert into food values(5,'small','tin','carrots');
insert into food values(6,'medium','bag','peas');
insert into food values(7,'large','tin','potatoes');
insert into food values(8,'small','bag','carrots');
insert into food values(9,'medium','box','peas');

The queries I run against the table might be "how many large boxes have I?" or "give me all the potatoes, I don't care about how they are packed". The idea is that I do not know in advance what columns I will be using in my predicate: it could be any combination. This is a common issue in a data warehouse.
So how do I index the table to satisfy any possible query? Two obvious possibilities:
First, build an index on each column, and the optimizer can perform an index_combine operation on whatever columns happen to be listed in the predicate. But that means indexing every column - and the table might have hundreds of columns. No way can I do that.
Second, build a concatenated index across all the columns: in effect, use an IOT. That will give me range scan access if any of the predicated columns are in the leading edge of the index key followed by filtering on the rest of the predicate. Or if the predicate does not include the leading column(s), I can get skip scan access and filter. But this is pretty useless, too: there will be wildly divergent performance depending on the predicate.
The answer is to invert the table:
create table inverted(colname varchar2(10),colvalue varchar2(10),id number);
insert into inverted select 'capacity',capacity,id from food;
insert into inverted select 'container',container,id from food;
insert into inverted select 'item',item,id from food;

Now just one index on each table can satisfy all queries:
create index food_i on food(id);
create index inverted_i on inverted(colname,colvalue);

To retrieve all the large boxes:
orclz> set autotrace on explain
orclz> select * from food where id in
  2  (select id from inverted where colname='capacity' and colvalue='large'
  3  intersect
  4  select id from inverted where colname='container' and colvalue='box');

        ID CAPACITY   CONTAINER  ITEM
---------- ---------- ---------- ----------
         4 large      box        potatoes


Execution Plan
----------------------------------------------------------
Plan hash value: 1945359172

---------------------------------------------------------------------------------
| Id  | Operation                                | Name       | Rows  | Bytes | C
---------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                         |            |     3 |   141 |
|   1 |  MERGE JOIN                              |            |     3 |   141 |
|   2 |   TABLE ACCESS BY INDEX ROWID            | FOOD       |     9 |   306 |
|   3 |    INDEX FULL SCAN                       | FOOD_I     |     9 |       |
|*  4 |   SORT JOIN                              |            |     3 |    39 |
|   5 |    VIEW                                  | VW_NSO_1   |     3 |    39 |
|   6 |     INTERSECTION                         |            |       |       |
|   7 |      SORT UNIQUE                         |            |     3 |    81 |
|   8 |       TABLE ACCESS BY INDEX ROWID BATCHED| INVERTED   |     3 |    81 |
|*  9 |        INDEX RANGE SCAN                  | INVERTED_I |     3 |       |
|  10 |      SORT UNIQUE                         |            |     3 |    81 |
|  11 |       TABLE ACCESS BY INDEX ROWID BATCHED| INVERTED   |     3 |    81 |
|* 12 |        INDEX RANGE SCAN                  | INVERTED_I |     3 |       |
---------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   4 - access("ID"="ID")
       filter("ID"="ID")
   9 - access("COLNAME"='capacity' AND "COLVALUE"='large')
  12 - access("COLNAME"='container' AND "COLVALUE"='box')

Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

orclz>

Or all the potatoes:
orclz> select * from food where id in
  2  (select id from inverted where colname='item' and colvalue='potatoes');

        ID CAPACITY   CONTAINER  ITEM
---------- ---------- ---------- ----------
         1 large      bag        potatoes
         4 large      box        potatoes
         7 large      tin        potatoes


Execution Plan
----------------------------------------------------------
Plan hash value: 762525239

---------------------------------------------------------------------------------
| Id  | Operation                              | Name       | Rows  | Bytes | Cos
---------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                       |            |     3 |   183 |
|   1 |  NESTED LOOPS                          |            |       |       |
|   2 |   NESTED LOOPS                         |            |     3 |   183 |
|   3 |    SORT UNIQUE                         |            |     3 |    81 |
|   4 |     TABLE ACCESS BY INDEX ROWID BATCHED| INVERTED   |     3 |    81 |
|*  5 |      INDEX RANGE SCAN                  | INVERTED_I |     3 |       |
|*  6 |    INDEX RANGE SCAN                    | FOOD_I     |     1 |       |
|   7 |   TABLE ACCESS BY INDEX ROWID          | FOOD       |     1 |    34 |
---------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   5 - access("COLNAME"='item' AND "COLVALUE"='potatoes')
   6 - access("ID"="ID")

Note
-----
   - dynamic statistics used: dynamic sampling (level=2)
   - this is an adaptive plan

orclz>

Of course, consideration needs to be given to handling more complex boolean expressions; maintaining the inversion is going to take resources; and a query generator has to construct the inversion code and re-write the queries. But In principle, this structure can deliver indexed access for unpredictable predicates of any number of any columns, with no separate filtering operation. Can you do that with a normalized star schema? I don't think so.
I hope this little thought experiment has stimulated the little grey cells, and made the point that relational structures are not always optimal for all problems.
--
John Watson
Oracle Certified Master DBA
http://skillbuilders.com


Full Article

ed

Fireline Fused Cristal 0,06 mm nu voor maar € 10,00

By www.hengelspullen.nl
Published On :: vri, 03 okt 2014 12:00:29 GMT

Fireline Fused Cristal Merk: Berkley Lengte: 110 meter De nummer 1 transparante superlijn ter wereld. Kenmerken van de Fireline Fused Cristal: - 3x sterker dan een mono lijn - Ultiem gevoelig. - Schuurbestendig - Extreem sterk - Ook geschikt voor op de molen De lijnen zijn in drie verschillende diameters te verkrijgen. Iedere diameter heeft weer een andere draagkracht.


Full Article

ed

cormoran feeder hrengel

By www.hengelspullen.nl
Published On :: zon, 18 jan 2015 16:11:57 GMT

cormoran speciland feeder medium 13''/ 3.90cw 25-80 grincl. 3 tipsincl. tanager 2000 rd molen


Full Article

ed

shakespeare feederhengel

By www.hengelspullen.nl
Published On :: zon, 18 jan 2015 16:15:45 GMT

te koop:shakespeare mach 1 xt 11 ft commercial feeder''l 3.30 m / max line 8 lbs / 3.6 kgc.w. 3 ozincl. 3 tipsincl. mitchell tanager 2000 rd molennieuw*


Full Article

ed

feederhengel

By www.hengelspullen.nl
Published On :: zon, 18 jan 2015 16:22:50 GMT

te koop sun pass feeder 300incl. 3 tipsincl. mitchell tanager 2000 rd molennieuw


Full Article

ed

spro leo koot teamfeeder

By www.hengelspullen.nl
Published On :: zon, 18 jan 2015 16:28:41 GMT

te koop: spro leo koot teamfeedershor/mid t range 12 feet 3.60 m feedercustum designed by spro.incl. 3 tips en mitchell tanager 2000 rd molenalles nieuw


Full Article

ed

spro leo koot teamfeeder

By www.hengelspullen.nl
Published On :: zon, 18 jan 2015 16:31:15 GMT

te koop: spro leo koot teamfeederul short range 11 feet 3.30 m feedercustum designed by spro.incl. 3 tips en mitchell tanager 2000 rd molenmeerdere van te koop.alles nieuw


Full Article

ed

engelse zitkoffer in combinatie met een techniworks alu feed

By www.hengelspullen.nl
Published On :: woe, 21 jan 2015 08:40:31 GMT

te koop compleete engelse zitkoffer in combinatie met een techniworks alu feederplateau.koffer is zoals u kunt zien op de fotos nog in goede staatvoorzien van twee schuiven aan de voorkanten een aan de zijkantonder het deksel is plaats voor vistuigen en in het zwarte gedeelte.de koffer is verder voorzien van verstelbare potenhengelsteun links of rechts aastafel/voerbak paraplusteun aan de achterzijdeen onderbak is dubbelwandig te gebruiken als koelbox.en in combinatie met het bovenste gedeelte van de koffer en het plateau heeft u een heerlijk zit station om te feederen maar ook om met de stok te vissen dus van alles mogelijk.twee verstelbare hengelsteunenverstelbere feeder steun en een grootte afsluitbare aasbak.interesse? doe een rieel bod en hij is voor jou.wegens omvang ophalen.


Full Article

ed

Chicago Bears sign restricted free agent tight end Josh Hill to an offer sheet

By www.fulltimefantasy.com
Published On :: Wed, 23 Mar 2016 13:15:23 EST

The Bears have signed restricted free agent tight end Josh Hill. The New Orleans Saints have five days to match the offer.


Full Article

ed

Need to Know Players: Tampa Bay Rays

By www.fulltimefantasy.com
Published On :: Wed, 23 Mar 2016 13:20:02 EST

Dr. Roto reveals two Tampa Bay Rays to look closely at in your 2016 Fantasy Baseball draft!


Full Article

ed

Dr. Roto?s Overrated Fantasy Baseball Players (Premium)

By www.fulltimefantasy.com
Published On :: Wed, 23 Mar 2016 13:41:20 EST

Dr. Roto lists one player from each position that he believes is overrated heading into the 2016 Fantasy Baseball season.


Full Article

ed

Scouting The NBA DFS - Wednesday, March 23 (Premium)

By www.fulltimefantasy.com
Published On :: Thu, 24 Mar 2016 16:34:10 EST

One of the last big slates of the NBA season is on the docket this Wednesday, so cash in on DraftKings and FanDuel with our top DFS plays


Full Article

ed

Scouting The NBA DFS - Wednesday, March 23 (Free Preview)

By www.fulltimefantasy.com
Published On :: Thu, 24 Mar 2016 16:34:47 EST

Fantasy Basketball Expert Nate Weitzer will help you cash with your DFS NBA lineups. This is a free preview of his PREMIUM NBA DFS Rundown!


Full Article

ed

Need to Know Players: Texas Rangers

By www.fulltimefantasy.com
Published On :: Thu, 24 Mar 2016 16:37:16 EST

Dr. Roto discusses two Texas Rangers to keep an eye on heading into the 2016 Fantasy Baseball season!


Full Article

ed

Dallas Cowboys Sign RB Alfred Morris

By www.fulltimefantasy.com
Published On :: Thu, 24 Mar 2016 16:37:57 EST

Fantasy Football Expert Mark Morales-Smith discusses the Fantasy impact of Alfred Morris moving from the Washington Redskins to the Dallas Cowboys!


Full Article

ed

2016 Fantasy Baseball 5 Star Rated Draft Kit

By www.fulltimefantasy.com
Published On :: Sun, 27 Mar 2016 14:31:05 EST

FullTime Fantasy Sports's 2016 Fantasy Baseball Draft Kit provides a comprehensive package of content that will help you DOMINATE YOUR LEAGUE!


Full Article

ed

Need to Know Players: Toronto Blue Jays

By www.fulltimefantasy.com
Published On :: Tue, 29 Mar 2016 16:25:25 EST

Dr. Roto discusses two players from the Toronto Blue Jays Fantasy Baseball owners should keep an eye on in 2016!


Full Article

ed

Need to Know Players: Washington Nationals

By www.fulltimefantasy.com
Published On :: Wed, 30 Mar 2016 16:40:00 EST

Dr. Roto breaks down two players you may want to target from the Washington Nationals in your 2016 Fantasy Baseball draft!


Full Article

ed

Scouting The NBA DFS - Wednesday, March 30 (Free Preview)

By www.fulltimefantasy.com
Published On :: Wed, 30 Mar 2016 16:41:58 EST

Fantasy Basketball Expert Nate Weitzer will help you cash with your DFS NBA lineups. This is a free preview of his PREMIUM NBA DFS Rundown!


Full Article

ed

Scouting The NBA DFS - Wednesday, March 30 (Premium)

By www.fulltimefantasy.com
Published On :: Wed, 30 Mar 2016 16:42:44 EST

This is a huge slate of NBA action today and the Daily DFS Breakdown will help you cash on DraftKings and FanDuel


Full Article

ed

Daily Dr. Roto: Disabled List Woes

By www.fulltimefantasy.com
Published On :: Thu, 31 Mar 2016 16:43:47 EST

Dr. Roto discusses the significance of the DL in Fantasy Baseball.


Full Article

ed

Improved RSS Newsfeeds

By dailyfisk.blogspot.com
Published On :: Thu, 2 Mar 2006 09:59:00 -0800

For your viewing pleasure we have improved our RSS newsfeeds. The feeds should be more readable and now come in three flavours.

You have three options to choose from:

1. Full Feed (the entire post);

2. Excerpts Only (a short intro to the post); or

3. Just Headlines only (self explanatory).

There are also three new options for joining our email newsletter. Just look at the right menu under the "Subscribe" menu.

Cheers!


Full Article