Hi All,
We have partition tables Total ( list ) and Track
( list and sub partition is range ).
We are going to implement in-db archival at table level.
The table has 3 years data.
Jul28-Total.txt (1.15 KB)Jul28-Track.txt (5.6 KB)Just want to keep only one year and remaining
datas are inactive.
Hence, we decide to create partition on hidden column. The hidden column name is ORA_ARCHIVE_STATE ( values 0 & 1 )
The tables has already partitioned.
How can i get that.
Is it possible to do partition in sub-partition?
Attached table ddl.
Thanks,