Last week I was asked by one of IT managers on how to generate reports from database. He’d like to remind his direct reports on ticket’s backlog status. His requirement is just simply to run a simple SQL statement and email the result out weekly. I quickly told him that you can just cron or …
I just passed the 11g OCP upgrade after many excuses to postpone it. I have to admit I was nervous a little bit because the last Oracle exam I’ve taken was more than one year ago. I was struggling a little bit at first. I tend to read too quickly (= careless). So at the …
One of Oracle 11g’s new features is an ease of capturing the initialization parameter values currently in memory into a file. create pfile from memory; create spfile from memory; create pfile=’/tmp/cur_pfile.ora’ from memory; This comes in handy when you’d like to quickly verify changes especially after executing “alter system set” with scope=memory. It also lets …
I just have time to install Oracle Enterprise Linux (OLE) on VMWare. The first error I encountered after trying to login into the 11g (11.1.0.6) database is this – [oracle@oralnx1 ~]$ sqlplus / as sysdba sqlplus: error while loading shared libraries: /opt/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied. Well, I guess this is …
A new extended partition syntax can be used to designate a partition without knowing its name. The syntax must refer to a possible value for the partition. This syntax works for all cases when you have to reference a partition, whether it be range, list, interval, or hash. It supports all operations such as drop, …
As a part of the button’s properties, an execution of “Automatic Row Processing (DML)” process either INSERT, UPDATE or DELETE (assuming those operations are allowed) can be controlled by selecting an appropriate Database Action as shown below. Many times, instead through a use of button, page submission is done by calling JavaScript “onSubmit” function. How …
