Catalogs are optional ways to group different schemas. A catalog contains all the schema (metadata) for a database object. A schema contains only the metadata information for a particular user or application. Model the physical layer after the way your database is structured.
A database can have either catalogs or schemas but not both. If your database has one or more schemas, you cannot create a catalog. If your database has one or more catalogs, you cannot create schemas.
In the Physical layer of a large repository, Oracle BI Administrators can create catalogs that contain one or more physical schemas.
- In the Physical layer, right-click a database object, and then choose New Object > Physical Catalog.
- In the Physical Catalog dialog box, type a name for the catalog.
- Type a description for the catalog, and then click OK.
The schema object contains tables and columns for a physical schema. Schema objects are optional in the Physical layer of the Administration Tool.