Re: changing a table owner name

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 26 Nov 2001 19:17:17 +0100
Message-ID: <u06mmhqucm5oa8@corp.supernews.com>

"Kevin Delsh" <kevin_delsh_at_yahoo.com> wrote in message news:fca3c675.0111260819.7e2ad14e_at_posting.google.com...
> Is there an Oracle SQL command to change the owner of a table.
>
> Thanks,
> Kevin

create table <newowner>.<tablename> as select * from <oldowner>.tablename or follow the exp/imp route.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon Nov 26 2001 - 12:17:17 CST