Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie: Need command to change owner of table

Re: Newbie: Need command to change owner of table

From: smart <smart_at_globalserve.net>
Date: Thu, 19 Nov 1998 18:07:01 -0500
Message-ID: <3654A495.FE012DE8@globalserve.net>


Hi,

        There are couple of ways to do it( I think):

  1. export it, and reimport under new owner.
  2. using sql statement, create table jim.terms as select * from jeff.terms;

Peter

bmolish_at_btsquared.com wrote:

> Our DBA has left and there is no one to help out, and I need to change several
> tables to a new owner.
>
> Such as
>
> Old: jim.terms
> New: Jeff.terms.
>
> What is the actual command to do this?
>
> Using oracle 7.34 on Nt box..
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Nov 19 1998 - 17:07:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US