What is a Schema ?

 The set of objects owned by user account is called the schema.

Showing Answers 1 - 5 of 5 Answers


  • Jan 9th, 2006

Three type of schema.....


Star schema

A single fact table with N number of Dimension


Snowflake schema

Any dimensions with extended dimensions are know as snowflake schema


Multiple Star (galaxy)

If the schema has more than one fact table then the schema is said to be Multiple star




  Was this answer useful?  Yes

A schema is a collection of components and database objects under the control of a given database user. Each Oracle Portal application maps to an Oracle database schema. The schema stores the components owned by the application. In addition, the schema can store the database objects on which the components are based.

You can map an application to schemas currently in the Oracle database where Oracle Portal is installed. When you create the schema, you must select the Application Schema check box to designate that applications can be built in the schema.


  • Jun 20th, 2012

Schema is a set of objects own by a Particular user..

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions