Re: Change owner of Objects

Chuck,

You can use the export utility to export the user and import utility to import. You can
either use the command line interface or the data manager gui. If the tables are always
being updated then you will need to get the users off the system, if these are static objects
then export/import and then point your synonyms at the new user. Use exp help=y or
imp help=y to get the specifics.

Phil Cook

Chuck Bayes <Chuck=Bayes%IM%NA=Hou_at_netgate.compaq.com> wrote in article <01bccead$f4441d60$61421cac_at_pdailey.im.hou.compaq.com>...
> Thanks in advance for any help or guidance you can provide.
>
> I've been given the task of changing ownership of 15 views, 7 tables, and
 5
> procedures. Of course this is an active database, and I want to try to
> minimize down time.
>
> Does anybody know of a way for me to do this without dropping and
> recreating these objects in Oracle 7.3 for NT? The tables aren't too
 big,
> but I'd like to avoid any down time at all, if possible.
>
> Again, thanks in advance for any help or guidance you can provide.
>
> Chuck Bayes
>
Received on Thu Oct 02 1997 - 00:00:00 CDT