Oracle 11.1.0.7:
I am looking for correct syntax that meets following requirement for given table:
create table A_payload(A_id number(19), created_date timestamp(6), Raw_p Blob, Proc_p Blob);
1. Interval partition every 15 days based on created_date
2. 64 Hash sub partition
3. Raw_p and Proc_p go in E_Blob tablespace with in row storage clause disabled. and rest of the row go in E_DATA tablespace
Could someone point me to some resource that would help me do the above or give me an example?
Edited by: user628400 on Sep 21, 2009 7:48 AM