Package 3 DBA Responsibilities

In Oracle, a column can be added by issuing an “alter table” command with an “add” option. In most cases the column can be added at the appropriate time, the load process is adjusted and the process will proceed seamlessly. If the new column has been added to the primary key of a table, all child tables will be changed as well. ................
................