Re: Newbie question: how to change ownership of a table

In article <3ie5dm$nnv_at_dcsun4.us.oracle.com> rmanalac_at_us.oracle.com (Roderick Manalac) writes:
>From: rmanalac_at_us.oracle.com (Roderick Manalac)
>Subject: Re: Newbie question: how to change ownership of a table
>Date: 22 Feb 1995 01:52:54 GMT
 

>Jonathan_at_jlcomp.demon.co.uk (Jonathan Lewis) writes:
>|> : > >
>|> : > > CREATE TABLE new_owner.table
>|> : > > as SELECT * FROM old_owner.table
>|> : > >
>|> Note: 'Create table as select from table' does _not_ use rollback segments
>|> or redo log whilst the statement is executing. Depending on Oracle version,
>|> I belive the only redo overhead is a final copy into the redo log of the
>|> completed table.
>|>
>|> On top of this, I bet there's a CPU cost of translation in import that
>|> does not exist in the 'create table as' option.
>|>
>|> --
>|> Jonathan Lewis

Does an import recreate grants and 'second hand grants'/etc. If so doesn't it seem the safest way?

Henry.
Henry_Okeeffe_at_Inmarsat.Org

All opinions expressed here are not necessarily the opinions of my employer. Received on Wed Mar 01 1995 - 11:00:16 CET