Hello,
I have a table with the structure below:
Create table MEASUREMENT(
DateNTime Timestamp(3) NOT NULL ,
Pulse Number(5,0) Default 0 NOT NULL ,
Value Number(15,5) NOT NULL ,
Fault Char (1) Default 'N' NOT NULL ,
Channel Number(22,0) NOT NULL
)
TABLESPACE mytbspc_data
/
Create UNIQUE Index medida_un_canal_dthr ON S4MED_MEDIDA (DateNTime,Channel)
TABLESPACE mytbspc_indx
/
There is a process which is responsible to insert records on the table.
The process inserts records ordered by Channel and DateNTime, but sometimes the records source might omit a block of records causing a hole on the records series.
How can I determine if is there any missing record?
Thank you very much.
Best regards.
Jayme Jeffman Filho