Below is snippet command for granting user table to another user declare cursor t_name is select table_name from user_tables ; command varchar2(500); begin for c in…
Database
Install ORACLE on AIX 6.1
Oracle 11g Installation procedure on AIX system v.6.1 environment, on IBM P-series machine is summarized from best practice at one of our client. This procedure,…
Rails + Mysql OSX
Today when running rails application using agains MySQL Database, got the following error : The strange thing is mysql already installed on my machine :…
Display Tag ajax pagination and Hibernate
Display tag is one of powerful tools for displaying collection on table template, light weight, customizable, and fully supported for java web application. Read more…
Oracle Datafile Recovery (ORA-01172)
Today, i Face a problem on oracle db server. the symptoms are : Try to login, but exception thrown, said ‘ORA-01033: ORACLE initialization or shutdown…
PostgreSQL and Hibernate ‘Upper case’ problem
Today, i find out strange buggy problem on postgresql and hibernate integration implementation … as an illustration, i have a table, named user with the…
Password life time on oracle
By default, user created in oracle has password expiration on 180 days. It means, when the time reached, the user will be forced to change…
Removing All Object Current Oracle User (Schema)
How to import oracle datapump file to a user which has an old version of imported schema ? The question is straight forward asking about…
Using sequence, DB2 and Hibernate
Several days ago, i found strange behavior in DB2 sequence using HIbernate ORM framework. i have created sequence named HIST_VND_DISTRICT_SEQ, with initial value 100 minimal…
Using old method export pump on Oracle 11g R2
Did u ever wanna export your oracle schema on 11g version R2, but the empty tables are not exported ? This is happened because of…