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: Brent Laminack <brent_at_cc.gatech.edu>
Date: 18 Jun 1998 15:24:12 -0400
Message-ID: <6mbpgs$siv@terminus.cc.gatech.edu>


ANSI SQL specifically prohibits moving a table from one schema (owner) to another. Why? I dunno.

brent

>
>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 Thu Jun 18 1998 - 14:24:12 CDT

Original text of this message

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