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. 

No comments:

Post a Comment

Popular Posts