Go thru this technotes. It will be very helpful for understanding all the situations.

http://otn.oracle.com/doc/oracle8i_8...a76995/toc.htm