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

In article <Pine.SV4.3.91.950219222437.11711A-100000_at_brisbane.DIALix.oz.au>

           gers_at_brisbane.DIALix.oz.au "Thomas Mudd" writes:

: The fastest way is probably to do an export and then do an import
: using the from user and to user options. This would be a lot easier on
: the rollback segments and would take a lot less cpu.
:

In response to

: > >
: > > 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