Re: Changing Ownership of Tables...Help

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.

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

Good Luck, Rober Prendin
David Parry <dparry_at_nu-pharm.com> wrote:

>Hello,
>
>Is there and easy way to change the ownership of a table to another
>owner? Here is the problem. I have a user that has created a lot of
>tables, he is leaving the company and now I need give the ownership to
>another user. Do I have to use export/import utility? Can someone point
>me in the right direction.
>
>
>Thanks in advance.
>
>System Specs
>Oracle 7.3.3
>SCO Unixware 2.1
>
>David Parry
>dparry_at_nu-pharm.com
Received on Thu Feb 12 1998 - 00:00:00 CST