Non Unique table names???

From: C. W. Biami <zcwb06_at_AMOCO.COM>
Date: 1995/05/23
Message-ID: <3ptcsj$d4q_at_tabloid.amoco.com>#1/1

I have a dilema. I am using a third party Oracle application written using PRO*C. Several tables in our database need to be initalized, export-drop-recreate, yearly. But of course, users want to be able to select which of these sets of tables they want to use, i.e. current-year, last-year etc. possibly multiple times within the application. The application does not allow us to change the name we use to reference these tables but we can manipulate the database ------ So   

I think it can be handled by not creating the table objects in the users schema. Instead create seperate tablespaces and schema for each year, grant the user privleges as though he were the owner and create a synonym for each table. We could then drop and recreate the synonym with the proper translation as needed. But this is a pain in the KA-HEWIE. Since I'm new at this I figure I'm probably doing things the hard way. Is there an easier solution??????????

---

opinions expressed are probably     | C. W. Biami   CWBiami_at_amoco.com 
somebody else's but there not       | 
claiming them                       |


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

The significant problems we face cannot be solved at the same level of thinking we were at when we created them...

1. Einstein

Received on Tue May 23 1995 - 00:00:00 CEST