confusion between database and schema terminology
ManjitDec 21 2006 — edited Dec 22 2006I had a argument with my friend regarding the terminology between a schema and database.I have a j2ee/oracle payroll application and it has a database.I called the database as payroll database with a schema.Similarly a tax database with another schema.In short each database has its own schema.
My friend argues that a database can have multiple schema !...I am confused.
Does that mean I have to say " I have Oracle database with payroll schema and tax schema "
Please help.