Re: Change owner of Objects

How about "CREATE usera.table AS SELECT * FROM userb.table;

This will create the table in user a's default tablespace and populate it with the current contents of user b's table. Of course user a must have permission to read user b's tables or this won't work.

I assume that all of the users of the tables and views you wish to move will log on as the new owner. If not you are going to have to do two things: first, drop the original tables so that there will be no references to "dead data" and second, go through any scripts your users have and qualify the ownership so that they will be referencing your new tables.

Jerry

Chuck Bayes wrote:
>
> 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