Hello ,
I inserted some data into a table with creating partitions on monthly. Once I am done with the insert query, I checked the counts for the partitions and they are matched, but when I check the partitions I can see the num rows and last analyzed fields are empty in partitions.
May I know the reason for that?
samples of partitions:
query:
PARTITION BY RANGE (CREDIT_POSTING_DATE)
(
PARTITION CD_199603 VALUES LESS THAN (TO_DATE(' 1996-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
NOCOMPRESS
TABLESPACE PCR\_DWH\_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER\_POOL DEFAULT
),
PARTITION CD_199604 VALUES LESS THAN (TO_DATE(' 1996-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
NOCOMPRESS
TABLESPACE PCR\_DWH\_DATA
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER\_POOL DEFAULT
)
I guess NOLOOGING is the BLOCKER HERE