Yesterday I tested migration of one of the oracle forms 10g release 1 application’s database from Oracle 10g Release 1 to Oracle 11g. Everything ran smooth and I was able to run my forms and do transaction and so on. But the problem started when I tried to run reports. When ever I try running [...]

[Read more →]

Recently I got my new book Oracle Database 11g New Feature on 11g from Amazon.com. Even though I know that now Oracle 11g has a new mechanism to keep the alert , trace and log file, but I wasn’t fully aware of the technical terms that oracle is using to define it. In fact starting [...]

[Read more →]

Normally, when I connect to Oracle, I don’t worry about case sensitivity of my password. But today, when I was trying to connect Oracle, I was contineously getting following error. Flashing message “ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE.”. I was out of clue why exactly this is happening [...]

[Read more →]

Recently while doing R&D, I came across the ADR Command Interpreter (ADRCI). Introduced in Oracle Database Release 11g, it is a command-line tool that one can use to manage diagnostic data. Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more. ADRCI has a rich command set, [...]

[Read more →]

On 13th October 2007, I wrote about “Understanding Virtual Columns“. Then Ray DeBruyn ask me a very good question, which I totally miss to ask myself when I was writing about it. What happens if I use: INSERT INTO myTable VALUES myTableRec or UPDATE myTable SET ROW = myTableRec Assuming I declare myTableRec as myTable%ROWTYPE, [...]

[Read more →]

On 12th july 2007, I wrote a post about new feature of 11g related to sequence. In this post I mention that in 11g we don’t need to use dual table to fetch next value of a sequence and using simple PL/SQL expression the next value can be fetched. Any way thats the old story [...]

[Read more →]

Oracle Audit Vault: Now it is more secure than ever before. Previously, skilled DBAs can view  or alter the data and can remove their footprints. By introducing one-way “lockbox”, once audit trail in , no one can do any change/alteration. It can be only view. One more thing about this is implemented using encryption techniques. Whoever will [...]

[Read more →]

For last few days I was busy packing my things plus doing some important task related to my Australia trip but at last got time to write about something new in Oracle 11g called Virtual Columns. First lets go through one situation, we have a sales table with Gross_Amount and Discount_Amount. Now Net_Amount := Gross_Amount [...]

[Read more →]

Previous 11g, if i want to refer the field of a ‘Table Of record’ with in FORALL, Oracle raises error as follows PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records Example: SCOTT>SELECT banner 2  FROM v$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Prod PL/SQL Release 10.2.0.1.0 – [...]

[Read more →]

The new Compound Trigger make it easier to handle a situation, where we want trigger fired at different point of time to share common data. Before Compound trigger, to handle such situation we required the use of packages variable so that data can be shared. But this approach gives rise to many complications such as [...]

[Read more →]