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

RE: Changing table owner

From: Victor de la Calle <v.calle_at_iberdrola.es>
Date: Sun, 3 Oct 1999 23:08:27 +0200
Message-ID: <newscache$o1q1jf$age@bartolo.ran.es>


You can export the table and import using fromuser=old_owner touser=new_owner.

Tony Pich <apich_at_viviance.com> escribió en el mensaje de noticias 7t25d7$2kg$1_at_diana.bcn.ttd.net...
> Hi all:
>
> I'm using Oracle 8.0 and I'm trying to change the owner of a specific
> table. Which is the SQL Sentence to do so, or how do I change the owner of
a
> table using the Enterprise Manager?
>
> Thanks a lot.
>
> --
> Tony Pich
>
>
>
Received on Sun Oct 03 1999 - 16:08:27 CDT

Original text of this message

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