You can use filters to help you find specific objects in the relational schema tree of the Mapping window. When a schema has only a small number of objects, you can find them quite easily. However, you may have difficulty finding a particular object in a schema that contains hundreds or thousands of objects. You can apply filters to the list of tables, views, and synonyms.
To apply a filter to the list of objects:
Open the Mapping window and expand the folder for the schema that contains your data sources.
Right-click the Tables, Views, or Synonyms folder, and choose Create Filtered List from the menu.
Enter all of part of the name you are looking for.
Click Help on the Create Filtered List dialog box for additional information.
To change a filter:
Right-click the Tables, Views, or Synonyms folder, and choose Edit Filtered List from the menu.
To remove a filter:
Right-click the Tables, Views, or Synonyms folder, and choose Remove Filtered List from the menu.
All of the objects of that type in the schema will reappear in the list.
Creating Mappings to Data Sources
Copyright © 2003, 2007, Oracle. All rights reserved.