>In answer to your other question - yes, you should have exclusive access
>(perform a database shutdown) whenever you are changing metadata. This
>doesn't mean just that the SYSDBA or the OWNER should have exclusive access
>when changing metadata. The transaction in which the change is being
>performed also has to be the only transaction active in the database.

Thanks, that answers my question. The table altered fine once I had the
only active connection.

So where can I find documentation on what I can change live and what I
shouldn't? I have a lot of docs, but I don't even know where to start with
this one. :)

Cheers.

Scott.