2 Replies Latest reply on Nov 15, 2018 10:22 PM by thatJeffSmith-Oracle

    partition table with nologging

    akhilreddy

      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