Re: Changing Ownership
Date: Wed, 11 Sep 2002 20:53:42 GMT
Message-ID: <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 Received on Wed Sep 11 2002 - 22:53:42 CEST