Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: change the owner of table

Re: change the owner of table

From: DBA <oracledba_at_rpdatasolutions.com>
Date: Tue, 05 Feb 2002 02:19:31 GMT
Message-ID: <3c5f4087.38687498@nntp.slnt.phub.net.cable.rogers.com> 





There's more than one method, however,  the cleanest and most complete
way of doing it would be export/import with the 'fromuser' and
'touser' parameters. This will take care of indexes, triggers, grants,
etc..



Good Luck



Robert



On Tue, 05 Feb 2002 00:49:24 GMT, "tshen" <tshen01_at_hotmail.com> wrote:



>hi, guys:

>

>   I want change some table's owner, how can I do that? thanks.

>

>                               Tao

>

>

Received on Mon Feb 04 2002 - 20:19:31 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US