Re: Changing Ownership

"Alex Ivascu" <alex_at_ivascu.comNOSPAM> wrote in message news:<q3Of9.77953$Jo.17806_at_rwcrnsc53>...
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:a20d28ee.0209110028.4f617fc_at_posting.google.com...
> > "Matt Goyer" <mgoyer_at_fairtunes.com> wrote in message
 news:<3d7e0e5a$1_2_at_spamkiller.newsgroups.com>...
> > > I erroneously created a bunch of tables with system and I'd like to
 change
> > > their ownership. Is that possible?
> > >
> > > Or should I just re-create the tables and dump the data in?
> > >
> > > Thanks,
> > > Matt
> >
> > export the affected tables
> > import them using fromuser=(system) touser=(correct_user)
> >
> > Hth
> >
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Don't mean to be disrespectful, but is it a good idea to do that w/ the
> system account? Or it doesn't matter?
>
> Alex Ivascu

Maybe I was a bit too vague. I said 'export the *affected* tables' , which implies a table level export, not an user level export. However to move them you still need to use fromuser and touser on import.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Thu Sep 12 2002 - 09:26:38 CEST