Problem

--When TMP table got created in Database and How can we Drop them.

Resolution

*Concept of TMP tables

1) Broadcasting a Tracking object to the sentinel server creates the current and historic table in Database.

1) If the Tracking object is configured with Keep previous records option checked in Composer , the TMP tables named as CUR_TMP_X and HIST_TMP_X would be created in DB which will contains the records temporarily till you have removed the object from server.

2) These tables would store the records of the Tracking objects for the previous time you sent it to server.

3) When you would again send the concerned Tracking Object to the Server it will contain all previous records (store from the TMP tables ) and these table will automatically get deleted , but if you remove Tracking Object from server ( which have keep previous records option checked ) and delete it from the composer then you have to Drop these tables(TMP) from database manually using DROP TABLE command. And these tables will be stored as BIN$ table in your Oracle Recycle bin which can be recovered whenever you want.