Re: RESEND: changing owner of table

From: Adrian Shepherd <Adrian.Shepherd_at_BTINTERNET.COM>
Date: 1998/01/26
Message-ID: <6aj2io$b5n$1@mendelevium.btinternet.com>#1/1

Export the table as a dba , with indexes and grants etc , import with fromuser set to the new user , touser set to the new user, once you have confirmed al is ok , drop the table in the old schema...

Unless there is a better way ?

Jose Manuel Araque wrote in message <34CD04AE.5E8ECD7B_at_vin.bellcore.com>...
>Anyone,
>
>how can I change the OWNER of a table created under Oracle after the
>table was already created? (the owner is set to the login that created
>the table on sys.dba_tables).
>
>Thanks in advance!
>
>jose manuel
>
>
>
>
Received on Mon Jan 26 1998 - 00:00:00 CST