|
|
Re: Tablespace encryption - Data Migration (3 Merged) [message #480382 is a reply to message #480374] |
Sat, 23 October 2010 03:04   |
John Watson
Messages: 8805 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
This is the technique for moving a table (the encryprion is not relevant) while DML is in progressconn jon/jon
create table t1 as select (*) from all users;
alter table t1 add constraint t1pk primary key (user_id);
create table interim as select * from t1 where 1=2;
select tablespace_name from user_tables where table_name='T1';
select tablespace_name from user_tables where table_name='INTERIM';
alter table interim move tablespace example;
exec dbms_redefinition.start_redef_table('JON','T1','INTERIM');
exec dbms_redefinition.finish_redef_table('JON','T1','INTERIM');
select tablespace_name from user_tables where table_name='T1';
select tablespace_name from user_tables where table_name='INTERIM'; There is more to it than this, but the above is a starting point for further research.
|
|
|
|