tomconlon7777777 wrote:

>
>>>Basically definitive information is what is being requested.
>
> Does anyone, anywhere know what/where this information is?
>

To the best of my knowledge, it's not documented - in part because most
of the developers consider that all metadata updates should be possible
on a live database with the following two caveats:

1) No one is allowed to access an object if there are uncommitted
metadata changes on the object. We could (but don't) enforce that.

2) Some metadata changes (e.g. building a new index) will quiesce all
changes to the object being changed. We do enforce that.

V2.0 removes the last known enforced limit on live metadata changes by
allowing foreign keys to be defined on a live database. Over time,
we'll get the bugs that make on-line metadata updates questionable.

Regards,


Ann