Re: Changing Ownership
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 11 Sep 2002 01:28:46 -0700
Message-ID: <a20d28ee.0209110028.4f617fc_at_posting.google.com>
Date: 11 Sep 2002 01:28:46 -0700
Message-ID: <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
Received on Wed Sep 11 2002 - 10:28:46 CEST