Re: Changing table ownership
From: Jim Gregory <jim.gregory_at_DaytonOH.attgis.com>
Date: 1995/08/02
Message-ID: <DCopIL.3zD_at_intruder.daytonoh.attgis.com>#1/1
Date: 1995/08/02
Message-ID: <DCopIL.3zD_at_intruder.daytonoh.attgis.com>#1/1
>>==========kristoff_at_baseware.com, 8/1/95==========
>>
>>Hi Everyone!
>>
>>Is it possible to change ownership of a table in Oracle 7?
>>
>>Thanks,
>>Eric
>>
>>
create table schema2.tablename as
select ... from schema1.tablename
drop schema1.tablename
crude using brute force but there is no
" alter table schema=newschema"
Hope this helps
Jim Gregory
Views and opinions expressed are mine and do not reflect
my empoyer's or client's.
Received on Wed Aug 02 1995 - 00:00:00 CEST