SQL & PL/SQL

Hi,
I've a specific question on a functional requirement. Looking ahead to receive some helpful sugestion from this forum.

**Requirement:**

Need to support address search for around 400 - 500 Million customer. Need to store unique address in DB. There is a table cust_address already in the db. With a combination of 7-8 columns in that table we can define a unique key and the search.

Issue:

Cust_address had 8 columns which combinedly create a unqiye address i.e. CITY , Street, Zip code. All these fields length come with a total around or more than 3000 length. Storing the column in CHAR semantics to support global address. However while trying to create the index it's failing with Ora - 01450.

Any alternative ideas?


Though of creating a unqiue numeric field (by using ora_hash function on all those 8 fields). If this field is persisted in the table the decision makin would be easier for unique address creation. However the ora_has function is creating duplicate key when we insert more than 66000 (65536) it creates a duplicate key.

Any ideas to support this requirement will be appreciated.

With Regards,

A..