Re: Changing the owner of a table

From: Ban Spam <ban-spam_at_operamail.com>
Date: Thu, 15 Nov 2001 01:38:51 GMT
Message-ID: <Xns9159B384E1FA7SunnySD@24.0.3.73>

"Christian Lundh" <coclol_at_telia.com> wrote in news:I3BI7.5671$R43.896956_at_newsb.telia.net:

> Or
>
>
> Create table user2.table_name as
> select * from user1.table_name...
>
> Lot's easier than import/export...
> Add storage paramters but pray for no long columns :)
>
> Brg
> Christian
>

While the method above will clone the table, what happens to indexes, triggers, default column values or comments? The answer to this question is left as an exercise to each reader. Received on Wed Nov 14 2001 - 19:38:51 CST