Is it possible for us to range partition a table which has unique column as timestamp stored in oracle in Unix Epoch format .
There are lot of options we have w.r.t to oracle partition but I want to know how can we partition a table which has Unix Epoch timestamp stored at database level.
As this column is referenced in the front-end, we want to do range partition on this column only.
This is how the table structure looks like .
Test_Table
Columns
Timestamp number
Reference id number
Value intege
The table is going to store one year worth of critical data and the timestamp column stores the exact unix epoch timestamp . We would be interested to partition the table into 12 partitions based on timestamp values for each month .
This is how the unix timestamp we are converting to date format using below sql.
select (TO_DATE('1970-01-01','YYYY-MM-DD') + unix_timestamp / 86400000) from dbname;