Neoview Database Administrator's Guide (R2.4)

• “Displaying Materialized Views and Their Properties” (page 77)

• “Changing Materialized Views” (page 78)

• “Dropping (Deleting) Materialized Views” (page 79)

• “Materialized View Groups” (page 79)

— “Creating Materialized View Groups” (page 79)

— “Displaying Materialized View Groups and their Properties” (page 80)

— “Changing Materialized View Groups” (page 81)

— “Dropping (Deleting) Materialized View Groups” (page 81)

• “Synonyms” (page 81)

— “Creating Synonyms” (page 82)

— “Displaying Synonyms and Their Properties” (page 83)

— “Changing Synonyms” (page 83)

— “Dropping (Deleting) Synonyms” (page 84)

• “Stored Procedures in Java (SPJs)” (page 84)

Schemas

Your Neoview platform is preconfigured with these schemas:

Is used for...This schema

All tables that database administrators create in the database for end users, including dimension

and fact tables.

All tables created by end users using the DB Admin tool or third-party tools that connect to ODBC

data sources.

USR

Displaying Schemas and Their Objects

1. Start DB Admin and log on using any user ID. The DBA role is intended for this task.

2. Click the Database tab. DB Admin displays existing schemas with their owners:

On all schema screens, you can use the buttons at the bottom of the screen to copy data to

your clipboard, a file, or a spreadsheet.

You can also expand Schemas to display a list in the left pane.

38 Managing Database Objects