Forum OpenACS Q&A: Porting packages from Postgresql to Oracle

Hi,

I am currently in the middle of porting a custom package to work with oracle. This custom package was created with postgresql as the db backend.

One little and possibly trivial issue I encountered is with the limit Oracle imposes on view and table names. Table and view names greater than 30 characters return "identifier too long" errors.

As much as possible I would not like to shorten or change any of these view or table names on fear of breaking it when it runs in pg.

Has anyone encountered this ?
Comments and suggestions ?

Thanks