Re: Changing Ownership of Tables...Help

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: 1998/02/13
Message-ID: <34E4898D.779CA6AE@ubs.com>#1/1

Robert Prendin wrote:
>
> Import/export woulds be a good way or you could also say
> create table new_owner.table_name as select * from
> old_user.table_name;
>
> with this method you will need to re-create the indexes.

The possible grants, constraints, procedures, views, synonyms must also be re-created.

>
> Personally, I would export them then import using the fromuser/touser
> parameters.
>

I agree with you.

rgds
eugen Received on Fri Feb 13 1998 - 00:00:00 CST