Oracle® Business Intelligence Server Administration Guide > Creating and Administering the Physical Layer in an Oracle BI Repository > Creating Physical Layer Folders >
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
- 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.
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
- In the Physical layer, right-click a database object, and then choose New Object > Physical Schema.
- In the Physical Schema dialog box, type a name.
- Type a description for the schema, and then click OK.
|