Change table owner

Posted in 2009

Georges Martin — Mon, 19 Jan 2009 15:55:15 — source: IIUG Forums & Mailing Lists

Hi Folks, is there a fast way to change a table's owner without dropping and recreating the table? Thanks _________________________________________________________________

↪ replying to Georges Martin

Bogdan BOTEZ — Mon, 19 Jan 2009 16:07:38 — source: IIUG Forums & Mailing Lists

On Mon, Jan 19, 2009 at 17:55, Georges Martin <georges_martin_1@hotmail.com> wrote: > Hi Folks, > is there a fast way to change a table's owner without dropping and recreating > the table? > Thanks No.

↪ replying to Georges Martin

Art Kagel — Mon, 19 Jan 2009 16:32:39 — source: IIUG Forums & Mailing Lists

No. Alternative: - create new table with temp name and correct owner - copy data - drop old table - rename new table - establish indexes, constraints - re-establish referencing constraints on other tables Art On Mon, Jan 19, 2009 at 10:55 AM, Georges Martin < georges_martin_1@hotmail.com> wrote: > Hi Folks, > is there a fast way to change a table's owner without dropping and > recreating > the table? > Thanks > _________________________________________________________________ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.