Hi Everyone,

I am new to Oracle. We are developing a web application. We used to use MS SQL Server to create a separate database for each customer user. Now we switch to Oracle. It seems that it is commen to have a single database with multiple schemas in Oracle. My question is -- What is the difference between single database and multiple databases in Oracle? Take our case as an example: We have 200 customers, so we can use a single database to create 200 schemas, OR we can create two databases and each database with 100 schemas. Which way is better?

Thanks.