Re: Changing the owner of a table

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 13 Nov 2001 07:31:48 +1100
Message-ID: <3bf031c6$0$1773$afc38c87@news.optusnet.com.au>

Yes: export it, then run import with FROMUSER=X and TOUSER=Y parameters.

Probably not exactly what you were after -but no, there's no 'alter table change owner' command.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Cameron Abbott" <cvabbott_at_altavista.com> wrote in message
news:9sokvt$29m$1_at_bcarh8ab.ca.nortel.com...


> Is there any way to change the owner of a table without dropping the table

> and re-createing it as a different user?

>

> Thanks

>

>

Received on Mon Nov 12 2001 - 14:31:48 CST