I am confused about relationship between schema and database instance. What is the difference between schema and İnstance in Oracle,Sql Server and DB2?
Asked
Active
Viewed 1,468 times
1 Answers
1
How much you can view in essence.
It is very popular to just have separate databases for many thing with one used schema per datebase, but say I want to have these two databases (history and production for example) in one. I may want to have two users that have two different schema.
One for History to be able to access the history tables/functions/etc.
One for Production for the same reason.
Each of these will have their own schema, on one database instance.
Another topic about schemas, why they are beneficial: What good are SQL Server schemas?
Pretty much the same question: Difference between database and schema
