Question: How to handle duplicate table names?

Hi,

I would appreciate hearing from anyone who has any insight into handling the use of duplicate table names. In the production version of the applictation this will not be a problem as the tables will be accessed via SQL*net thus having different remote database extensions.

The problem is that we are building a prototype using one database. While it is possible to place the tables into separate table spaces, I have not come across any mechanism for specifying which table space to look for a table. The only differentiation mechanism that I can find in Oracle is the use of the table owner as a prefix to the table name.

i.e.	GROUP1.STATUS_CODES
	GROUP2.STATUS_CODES

With this approach we would have to transform all of the table names in the application programs when we port them to the actual production server. i.e. GROUP1.STATUS_CODES --> STATUS_CODES_at_SITE1 etc...

Any alternative solutions would be greatly appreciated.

Thanks,

Todd

Wm. Todd Bealor			     LINC Project
Systems Developer		     E-mail: tbealor_at_mda.ca
MacDonald Dettwiler		     Phone:  +1 (613) 723-7667 x28
240 - 1101 Prince of Wales Dr.	     Fax:    +1 (613) 723-7832
Ottawa, Ontario, Canada K2C 3W7	     URL:    http://www.mda.ca
			


------------------------------------------------------------------