Monthly Archives: March 2008

Functionality of dbms_rowid

dbms_rowid This package can be used to obtain information regarding the physical location of rows in a table, or the contents of a particular block.

Posted in Oracle | Comments Off

Using FTP without input.

How many times have you needed to run ftp un-attended, to fetch a backup overnight or duplicate large amounts of data to another directory? We regularly do this between systems, more often than not for standby database creation. Here’s how … Continue reading

Posted in Unix/Linux | Comments Off

Set autotrace on fails.

Sometimes you want to trace the functionality of a query you are executing, for which autotrace should be set on. However, there are steps to be taken to set this up.    

Posted in Oracle | Comments Off

Driving and Driver Tables.

What are the driving and driver tables in an oracle SQL statement?

Posted in Oracle | Comments Off