Maximum no of tables in an oracle database

For the OLTP app we are developing, we have the following scenarios, 1. For each user created a separate schema is created(Set of tables based on a template schema). We
have around 300 tables in the template schema. The maximum no of users that the app would register would
be around 300. and that would amount to 90,000 tables. The figure looks to be very high and never heard
of in case of any database. Can any one tell me what is the maximum number of tables a oracle database
can support and any information about an existing database wherein such huge number of tables are handled.
2. The second scenario could be keeping the data related to all the users in a single schema and use
relations between the tables. But the system handles proprietary data and data should not be accessible
to any other user other than the one it is intended for.

what would be the best solution?

Thanks in advance
Bala Received on Wed Dec 12 2001 - 20:16:27 CET