Change owner of Objects

From: Chuck Bayes <Chuck=Bayes%IM%NA=Hou_at_netgate.compaq.com>
Date: 1997/10/01
Message-ID: <01bccead$f4441d60$61421cac@pdailey.im.hou.compaq.com>#1/1

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 Wed Oct 01 1997 - 00:00:00 CDT