Once a disparate database table is linked into the Oracle database as a VIEW, it remains in the database until the VIEW and the supporting Periscope structures are deleted.

To demonstrate Periscope access we will perform a simple SELECT using the Oracle OEM Console.

Select the VIEWs in the Periscope schema.

  Periscope tables are created as Oracle VIEWs