Re: Changing Table Owner

From: dave mausner <dmausner_at_ameritech.>
Date: Wed, 08 Dec 1999 04:39:10 GMT
Message-ID: <qvl34.282$IN6.26480@nntp0.chicago.il.ameritech.net>

In article <19991207231121.00668.00000097_at_ng-fo1.news.cs.com>, julanehill_at_cs.com (JulaneHill) wrote:
>Is there an easy way to change the table owner? We have over 300 tables in an
>instance and need to be able to change the name somehow!

official way: export by owner, drop tables, import fromuser=a touser=b.

there are "illegal" ways to do this by goofing the data dictionary that can land you in the dog house but do not involve exporting the data.

--
Dave Mausner, Senior Manager, Braun Consulting Inc., Chicago. Received on Tue Dec 07 1999 - 22:39:10 CST