Oracle table name length restriction
Hi everyone,
As you could see from the last few posts, Oracle has been keeping me busy. I am now very close to successfully migrating my SQL Server 2000 database to Oracle 9i.
Oracle has a restriction on the length of the table names (< 30 characters or so). Is there a way to get around that? Most of my SQL server tables are greater than 30 characters. It will entail a lot of changes in the database views and procedures plus a lot of change in the C++ and ASP.NET code. Is there a way to go round that restriction?
One thought I had was to use synonyms, but synonyms seem to have a restriction as well and did not seem to work from an SQL call. So, if someone has any thoughts and suggestions on the matter, please let me know.
Thanks,
Pankaj
P.S: Thanks to all, esp. Justin for the help.
|
