Duplication of stored data

We have oracle 8i for border checkpost automation where truck entry details are stored . Many a time the truck data entered once get duplicated several time. How to filter out such duplicated data. As a part of this data-storage becomes huge. Please ad开发者_开发知识库vise how to overcome this problem

The standard method is to use a UNIQUE constraint.

This depends upon the discreetness of truck data. If these are same trucks that go in/out every day then instead of storing new entry for each truck you can Create a new Truck Detail table and Put a Foreign key in CheckPost entry Table and just enter new entry every time it passes with Entry details.

But if every day new trucks go in/out then creating New Truck Detail table won't be that much feasible and your existing Schema is optimum for this situation.

For Performance issues you should look in table Partitioning.