Re: Newbie question: how to change ownership of a table

The fastest way is probably to do an export and then do an import using the from user and to user options. This would be a lot easier on the rollback segments and would take a lot less cpu.

Tom

On 18 Feb 1995, Craig
Kasold wrote:

> In <792927855.4725_at_pyra.co.uk> markb_at_pyra.co.uk (Mark Bluemel) writes:
>
> >
> >In <D3t6zM.5wz_at_mail.auburn.edu> jgraves_at_eng.auburn.edu (Jeff Graves)
 writes:
> >
> >
> >>Hi,
 

> >> What is the right/best way to change the ownership of an existing
 table or other object?
> >
> >You can't, as far as I know. You have to create a new object with the
 correct
> >ownership, for example (with CREATE ANY TABLE priviledge) :-
> >
> > CREATE TABLE new_owner.table
> > as SELECT * FROM old_owner.table
> >
> >[Snip...]
> >
> >I'll be interested to see any other suggestions ...
> >--
> >Mark Bluemel Unix/Oracle Trainer and Consultant
> > My opinions are my own, but I'll share them
> > All solutions to problems are offered "as is"
> > and without warranty - you have been warned :-)
> >
> >
>
> You would have to go into the system tables and make changes to the data
> dictionary. YOU DO NOT WANT TO DO THIS. You could create a new table
> and then delete the old one. (If they let you).
> Craig
>
>
>

                 ,,,
                (o o)
 +----------oOO--(_)--OOo-----------+   
 |                                  |Tom Mudd gers_at_brisbane.DIALix.oz.au
 |         No Worries Mate          |A displaced San Diegan living down
 |                                  |under. The 49rs got lucky.
 +----------------------------------+