A reader, March 13, 2018 - 12:25 am UTC
Martin Rose, March 14, 2018 - 11:10 am UTC
Many thanks for your reply.
It'll be a relief to no longer have to try & judge the SIZE, only to find I've got it wrong. ;-)
March 16, 2018 - 3:55 am UTC
glad we could help
Seems like Fast Ingest is not working on tables partitioned by time interval
A reader, June 05, 2020 - 11:08 pm UTC
I'm trying to do Fast Ingest on a table partitioned on timestamp interval -
drop table eventlog;
CREATE TABLE eventlog
(
EVENT_TIMESTAMP TIMESTAMP WITH TIME ZONE,
EVENT_TIMESTAMP_UTC TIMESTAMP GENERATED ALWAYS AS (SYS_EXTRACT_UTC(EVENT_TIMESTAMP)),
...
)
SEGMENT CREATION IMMEDIATE
PARTITION BY RANGE (EVENT_TIMESTAMP_UTC) INTERVAL (NUMTODSINTERVAL (2, 'MINUTE'))(PARTITION OLD_DATA VALUES LESS THAN (TIMESTAMP '2013-01-01 00:00:00 UTC'));
SQL> alter table eventlog memoptimize for write
*
ERROR at line 1:
ORA-62165: MEMOPTIMIZE FOR WRITE cannot be enabled on table with specified partitioning type.
I'm not able to find documents specifying why this type of partition are not supported (and what are supported partitioned types).. Any comments or work-around would be greatly appreciated..