Using dbms_redefinition
From: skyste- <ste_at_nospam.ste.it>
Date: Tue, 15 Sep 2009 09:26:59 +0200
Message-ID: <7h8tu3F2sbq6iU1_at_mid.individual.net>
Hello all,
Date: Tue, 15 Sep 2009 09:26:59 +0200
Message-ID: <7h8tu3F2sbq6iU1_at_mid.individual.net>
Hello all,
It's possible instead run
alter table OWNER.TABLE nologging
alter table OWNER.TABLE move storage (initial 65536) pctfree 10 initrans
1 tablespace TBS nologging parallel 4;
alter table OWNER.TABLE logging
use dbms_redefinition.something? I'm looking on manual but I do not see a solution.
Thanks
Ste
Received on Tue Sep 15 2009 - 02:26:59 CDT