Re: Changing table owner

Actually, it can be harder than this. If the table that you're dbexporting and dbimporting is a parent table in a foreign-key relationship, you'll also need to deal with that. I'm not sure, I've never done this type of thing before, but I would imagine that disabling the constraint would not be enough, since you need to at least momentarily drop that parent table. You may need to get the DDL for any constraints, drop those constraints, and then re-apply them after you've re-imported the table. All of this is to say nothing about indicies. :) Have fun. Kind regards, John. In article <7h04mg$kes@lotho.delphi.com>, Randall Young <ryoung@BIX.com> wrote: > GQG wrote: > >How can I change the owner of a table? > > dbexport the table, alter the schema, and dbimport the table. It's that hard. > > Randall Young > ryoung@bix.com > -- <><><><><><><><> John Bejarano bebe stores, inc. <><><><><><><><> --== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.---