and, not only will all your hideous names be used verbatim, but they will be case-sensitive. If you take advantage of this feature, you should be slapped. I guess the reason Oracle makes this possible in the first place is so that an import can be accepted from a source - like MS Access - regardless of how awful its names are.

Anyway, here's a PL/SQL cure for bad table and column names.(link to code)

/*Renames tables and columns to be Oracle-legal.

SET LINESIZE 200 before running to avoid unwanted page breaks.Run from an account with privileges to - access v$reserved words - alter the appropriate tables

Thanks to Eddie Awad for his description of v$reserved words:http://awads.net/wp/2007/01/10/what-does-reserved-y-really-mean/