Re: Changing owner of a table

From: <mujeeb_ur_rehman_at_hotmail.com>
Date: Sat, 20 Jun 1998 19:15:07 GMT
Message-ID: <6mh1nq$fbj$1@nnrp1.dejanews.com>

In article <3588ca08.1313849_at_news.zeitung-online.net>, stefan_at_westner.org (Stefan Westner) wrote:
>
> Hello,
>
> I have greated some tables with the owner 'smith' and want to change
> the owner of all tables from 'smith' to 'webber'. Is this possible?
>
> Thanks
>
> Stefan Westner
>

The easy and fastest way is to export user smith using Oracle exp program and then import all the objects under user webber using the imp program.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sat Jun 20 1998 - 14:15:07 CDT