Attaching an Oracle Express database

In order to make an Express database available as a data source for a query, you must attach the database. If you want to fetch data from multiple sources, you can attach more than one database concurrently.

Important: Do not attach multiple databases that use the same object names. Doing so can produce unpredictable results.

To attach a database:
  1. In the Express Query dialog box, choose Attach Database.

  2. Locate the database file that you want to open.

  3. Choose Open to attach the database file.

  4. To attach additional databases, repeat Steps 1 through 3.

See also

Using the Express data source

About working with Express data