Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How much space does CLEAN_Address require in an Oracle Database?

April 26, 2017CLEAN_Address oracle database require

0

Posted

How much space does CLEAN_Address require in an Oracle Database?

1 Answer

0

Posted

The general answer to how much space is used in Oracle is: Very minimal, since the data files don’t reside within Oracle, but on the file system. * The Oracle Database only holds the lookup tables and PL/SQL procedures, plus the postal codes table, which contains about 70K records for all city, state, zip combinations. Altogether this is about 50MB in Oracle. * The data files for the Basic USPS® product are about 500MB, plus any options like DPV™ (900MB), GeoCoder (500MB), Canada (450MB), Rest of World (up to 3GB depending on countries).