Hi! I am having a hard time figuring out the following scenario. I have a table that has a dynamic partition let's say by CLIENT_ID. E.q,
CREATE TABLE CLIENT_EVENTS (
CLIENT_ID NUMBER NOT NULL,
CLIENT_NAME VARCHAR2(48 BYTE) NOT NULL,
CLIENT_TIME TIMESTAMP(2) DEFAULT SYS_EXTRACT_UTC(SYSTIMESTAMP)
)
TABLESPACE USERS
STORAGE (INITIAL 64 K
NEXT 1 M
MAXEXTENTS UNLIMITED)
LOGGING PARTITION BY LIST (CLIENT_ID) AUTOMATIC (PARTITION P_CLIENT_1 VALUES (1));
Not only I'd like to partition by the CLIENT_ID, I would also like to partition by CLIENT_TIME grouped into MONTHs. I cannot change the CLIENT_TIME data type.
Is it possible? If yes, how?
Infinite thanks in advance.