Hi,
Given these partitions:
SQL> select * from all_tab_partitions where table_name = 'TE_OI_TDC_MD';
TABLE_OWNER TABLE_NAME COM PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESS COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_ FLASH_C CELL_FL GLO USE IS_ PARENT_TABLE_PARTITION INT SEGM
------------------------------ ------------------------------ --- ------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------ ------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- ------- -------- ------------ ---------- ---------- ------------ ---------- ---------- ----------- ----------- ----------------- ------- ------- ------- --- --- --- ------------------------------ --- ----
UMDAINGU TE_OI_TDC_MD NO 2020_09_13 0 TO_DATE(' 2020-09-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 1 DATAINGU01 0 1 255 212992 1048576 1 2147483645 2147483645 YES ENABLED BASIC DEFAULT DEFAULT DEFAULT NO NO NO NO YES
UMDAINGU TE_OI_TDC_MD NO 2020_09_14 0 TO_DATE(' 2020-09-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 2 DATAINGU01 0 1 255 212992 1048576 1 2147483645 2147483645 YES ENABLED BASIC DEFAULT DEFAULT DEFAULT NO NO NO NO YES
UMDAINGU TE_OI_TDC_MD NO 2020_09_15 0 TO_DATE(' 2020-09-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 3 DATAINGU01 0 1 255 212992 1048576 1 2147483645 2147483645 YES ENABLED BASIC DEFAULT DEFAULT DEFAULT NO NO NO NO YES
Why does Oracle give this error?
SQL> select count(*) from TE_OI_TDC_MD PARTITION (2020_09_13);
select count(*) from TE_OI_TDC_MD PARTITION (2020_09_13)
*
ERROR en linea 1:
ORA-00933: comando SQL no terminado correctamente
Regards, Jose Luis