Home » RDBMS Server » Security » Tablespace encryption - Data Migration (3 Merged) (Oracle 11g, 11.2.0.1.0, AIX 6.1)
Tablespace encryption - Data Migration (3 Merged) [message #480374] Fri, 22 October 2010 16:20 Go to next message
snookala
Messages: 2
Registered: October 2010
Junior Member
Is it possible to migrate everything (tables, indexes) from a unencrypted to encrypted tablespaces online i.e. while the database is being used (DML)? Thank you.
Re: Tablespace encryption - Data Migration [message #480378 is a reply to message #480374] Fri, 22 October 2010 17:09 Go to previous messageGo to next message
BlackSwan
Messages: 21955
Registered: January 2009
Senior Member
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_redefi.htm

Above might work for you, then again it might not.
Re: Tablespace encryption - Data Migration (3 Merged) [message #480382 is a reply to message #480374] Sat, 23 October 2010 03:04 Go to previous messageGo to next message
John Watson
Messages: 4093
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 progress
conn 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.
Re: Tablespace encryption - Data Migration (3 Merged) [message #480555 is a reply to message #480374] Mon, 25 October 2010 12:52 Go to previous message
snookala
Messages: 2
Registered: October 2010
Junior Member
Thanks for pointing me to the right direction, appreciate your help.
Previous Topic: need to encrypt a file with GPG using a pgp public key
Next Topic: User management
Goto Forum:
  


Current Time: Mon Apr 21 02:57:09 CDT 2014

Total time taken to generate the page: 0.05857 seconds