Creating Physical Layer Catalogs and Schemas

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.

NOTE:  You must create a database object before you create a catalog object or a schema object.

Creating Catalogs

In the Physical layer of a large repository, Oracle BI Administrators can create catalogs that contain one or more physical schemas.

To create a catalog

1. In the Physical layer, right-click a database object, and then choose New Object > Physical Catalog.
2. In the Physical Catalog dialog box, type a name for the catalog.
3. Type a description for the catalog, and then click OK.

Creating Schemas

The schema object contains tables and columns for a physical schema. Schema objects are optional in the Physical layer of the Administration Tool.

To create a schema

1. In the Physical layer, right-click a database object, and then choose New Object > Physical Schema.
2. In the Physical Schema dialog box, type a name.
3. Type a description for the schema, and then click OK.