How do I Justify a one-to-one relationship:

A database developer asked me a couple weeks ago to justify the use of one-to-one relationships within his design document. He stated that the only thing he found on the web concerning one-to-one relationships was ‘Use them when appropriate for your situation’. Now if that is not helpful, I do not know what is. But the web does provide a lot of that advise.

One-to-one relationship: Defined as the existence of exactly one record in Table A that corresponds to one record in Table B.

With the release of 10g, a database can be cloned from one location to another by use of the Oracle database Creation Assistant.  However, this feature along with many of the new 10g features is worrisome to the veteran database administration crowd.  The main reason for this worry is the lack of knowledge our junior associates are getting due to the new EM tool.  They are not able to function in a telnet environment and trying to get them to perform any tasks using SQL*Plus is nearly impossible.  Do not miss our point.  The new EM tool provided by Oracle is a great improvement over past enterprise manager versions, however every tool has its place and a DBA must know far more than a GUI.  The instruction set detailed below for the cloning of an oracle database is valid in multiple versions of Oracle from 8.1.5 to 10g and has the added benefit of being performed over a telnet or ssh connection.