Re: Non Unique table names???

C. W. Biami (zcwb06_at_AMOCO.COM ) writes:
> 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
 [snip]
>
> 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??????????

Well, you're going to have to take _some_ action to deal with the requirement, and what you've come up with seems about as simple an approach as is possible, short of buying an application that meets your requirements to start with....

W.C. Epperson        "These opinions are not only someone else's,
Sr. SE                this isn't even me using this account."