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: Changing the owner of a table

Re: Changing the owner of a table

From: Christian Lundh <coclol_at_telia.com>
Date: Wed, 14 Nov 2001 21:08:56 GMT
Message-ID: <I3BI7.5671$R43.896956@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



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 Wed Nov 14 2001 - 15:08:56 CST












Original text of this message













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