creating seperate but same database for differnt type of data-suggestion required

From: harish <harishksh_at_yahoo.com>
Date: 11 Mar 2003 05:06:45 -0800
Message-ID: <ff46df6e.0303110506.5a343f8e_at_posting.google.com>

I am having an application that has oracle 8i as database and forms and reports6i as front end.
around 30 tables are there in my database. this database maintains aircraft related data.
now i want to have seperate databases(each consisting of same 30 tables) for each aircraft.
my idea to implement this is

1)create seperate user for of each aircraft.
2)allocate seperate tablesspaces for each user.
3)dump all the 30 tables into each user using export and import.

 from now onwards the database that i am using will be based on the username with which i login to the application. suppose, i login into the application as the user AIRCRAFT1 then the application will use the data located in AIRCRAFT1 tablespace. suppose, i login into the application as the user AIRCRAFT2 then the application will use the data located in AIRCRAFT2 tablespace. Now how far is the above mentioned method is efficient? any other better alternative is there for maintaing seperate databases for each aircraft
.(all the database contain the same table definitions but different data). Received on Tue Mar 11 2003 - 14:06:45 CET