Data Extraction at DB Level

[sowdip]

Hi,

I have Write Optimized DSO of huge volume (12 TB) close to 3 yrs.

Now I want to retain data for 6 Months , but all traditional deletion methods fail as with dumps.

Selective loads to another DSO isn't helping either.

I was thinking whether I can create small tables out of this big active table at Oracle DB level. 

My question is

1) Is it possible to create these smaller table at DB level ?

2) If I succeed the above , how can load this into a brand new DSO ?

Thanks,

Prashanth

[sowdip]

Sure will do.

Thanks a lot Matthew !

I'm closing this discussion.