30 character limit / workarounds?

Hi,

I am generating SQL and PL/SQL code from data. If I use the table and identifier names that a "naive" approach suggests then I often run into the 30 character limit for names and identifiers.

1. Is there any way to extend them beyond this limit?
2. If not (which I suspect), I'm looking for ideas for lossless and reversable compression of PL/SQL-identifiers into PL/SQL-identifiers.

Thoughts about other solutions:
As my names typically have a "depth" of 2 (i.e. "<name1><delimiter><name2>" I'm wondering about workarounds:

1. create user <name1>; create table <name2>; grant all on <name1>.<name2> to ...
2. create package <name1>, create package-local table <name2> (if there is such a thing)

Solution a) has some appeal to me (would make some things easier) but it requires the ability to create users and assign grants - which normal users don't have. I could generate an sql-script that does it for me and invoke it with sysdba privileges - but that would make the system vulnerable to attacks, wouldn't it?

Yours,
Stephan Received on Sun Nov 16 2003 - 16:47:33 CST