[CTPP] Files for importing demographic profiles into Oracle

Probably Microsoft Access is more than adequate for handling the demographic profile information. However, I wanted to practice manipulating the the demographic profile i <<dp_profiles_oracle.zip>> nformation in Oracle to prepare myself for the Summary File 3 release. The attached zip file contains files for creating and loading the demographic profile tables into Oracle. I loaded CT first, and then loaded NY and NJ. It would be easy for me to modify the files and load the national summary tables as well. Because of my process, the control files are different for NY and NJ because I was appending the data to an existing populated table. Oracle users will most likely need to edit the files to change the paths and file names. I added ".txt" to the batch files so that anti-virus software does strip the attachments and I do not get hate mail from system administrators. I also changed my userid information for obvious reasons. Daryl -- Daryl Scott South Western Regional Planning Agency Stamford Government Center 888 Washington Blvd., 3rd Floor Stamford, CT 06901 Tel: (203) 316-5190 Fax: (203) 316-4995 E-mail: dscott(a)swrpa.org