1. Building Semantic Models in Oracle Analytics Server
  2. Create and Build Your Model
  3. Build a Semantic Model's Physical Layer
  4. Delete a Physical Table

Delete a Physical Table

Deleting a physical table also deletes its dependent objects. For example, columns, keys, and joins.

You can't delete a table that an alias table is using as its source. You must first delete the alias table.

Instead of browsing to the physical table that you want to delete, you can search for it.

  1. On the Home page, click Navigator and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer.
  4. In the physical layer pane, locate and right-click the table you want to delete. Click Delete.
  5. When prompted, click Save All.