Monthly Archives: April 2016

Restore Production Database As Test On The Same Host When Using OMF On It

Posted on 26 April 2016 by Radosław Cisz

Recently I stepped on interesting issue.. I was suppose to restore database on the same host where source production database was running… In general, not big deal…lots of procedures to follow, but what when source database uses OMF (Oracle Managed … Continue reading →

Posted in Oracle DBA Advanced | Leave a comment

Instalacja APEX 5 na Oracle 11g XE na Windows

Posted on 17 April 2016 by kosma

1. Wchodzimy na stronę http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html i pobieramy aktualna wersje APEX. W momencie redagowania tego posta jest to wersja 5.0.3

Posted in Oracle APEX, Oracle APEX Advanced | Tagged , , , | Leave a comment

Connect by level vs recursive with (CTE) for generating values

Posted on 10 April 2016 by Rafal Stryjek

Hi All, Have you ever wondered what is the difference between generating records using connect by level and recursive with in CTE (available from Oracle 11R2)? I did short ora-investigation 🙂

Posted in Oracle, Oracle DBA, Oracle DBA Basic, Oracle SQL, Oracle SQL Tuning | Tagged , , , | Leave a comment