Creating a Materialized View

Previous

Next

---

To create a materialized view:

1. On the Database Home Page, click the Object Browser icon.

   Object Browser appears.

2. Click Create.

3. From the list of object types, select Materialized View.

4. Define the materialized view:

   1. Materialized View Name - Enter a name.

   2. Query - Specify a query to define the view.

      To access Query Builder or SQL Command Processor, click the appropriate link at the bottom of the page. The selected tool appears in a pop-up window. Once you generate the appropriate SQL, click Return to automatically close the popup window and return to the wizard with the SQL.

   3. Click Next.

      A confirmation page appears. To view the SQL used to create the materialized view, click SQL.

5. Click Create.