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

Re: Changing owner of a table

From: JHY <jhy_at_earthling.net>
Date: Mon, 29 Jun 1998 20:55:25 -0400
Message-ID: <6n9d1m$dpg@bgtnsc01.worldnet.att.net> 





If you don't want to export/import you can use CREATE TABLE tab as
SELECT * FROM SMITH.TAB.


Stefan Westner wrote:



> Hello,


>


> I have greated some tables with the owner 'smith' and want to change


> the owner of all tables from 'smith' to 'webber'. Is this possible?


>


> Thanks


>


> Stefan Westner





Received on Mon Jun 29 1998 - 19:55:25 CDT












Original text of this message













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