Finding database schemas and objects

Oracle Portal offers several methods for finding a schema or database object such as a table, view, or procedure. You can use the:

• Database Objects Navigator. You must know the name of the schema or the schema where the object is stored to use this method.

• Find field in the Database Objects Navigator. You only need to know the name of the schema object

• Find portlet. You only need to know the name of the schema or object. The Find portlet is one of the tools provided by Oracle Portal. To use this portlet, you must customize a page and add the portlet to it.

You must have View or higher access privileges on schema or the schema that contains the object to use any of the above methods.

To find a schema using the Database Navigator:

1. Click on the navigation shortcut bar.

2. Click the Database Objects tab in the Oracle Portal Navigator.

3. Click Path: Database Schemas.

   Note If you are already on the tab page displaying database schemas, you don't need to click this link.

   The Name column on the Database Objects tab contains a list of all schemas in the database on which you have View access privileges.

To find an object using the Database Navigator:

1. Follow steps 1-3 above.

2. Click the schema Name. The Name column updates with a list of objects stored in the schema you selected.

3. Scroll down to the database object you want to find.

4. (Optional) The actions you can perform on an object display in the Actions column next to each object. Depending on your level of schema-level access privileges, you can perform tasks such as:

   • query and update table and view contents.

   • execute database procedures and functions.

   • view information about triggers, synonyms, or indexes.

   • export an object.

To find a schema or object using the Find field of the Database Navigator

1. Follow steps 1-3 above.

2. In the Find field at the top of the Navigator, enter the name of the object, then click Go to search for an object. You can use the % wildcard in your search, for example, sc%.e% or em% to find the EMP object in the SCOTT schema.

3. 

4. Note You can qualify your search for an object with the schema that owns it. For example, you can enter SCOTT.EMP in the Find field to search for an object called EMP in the SCOTT schema.

To find an object using the Find portlet:

1. In the What is the name of the object you are for? list, choose Database.

2. In the What is the name of the object you are looking for? field, enter the name of the database portlet. You can use the % wildcard in your search; for example, EMP% to find objects named EMP or EMPLOYEE_TABLE.

   

3. Click Find. The Find Results page displays all objects that match your search criteria. The object name will be prefixed with the name of the schema that owns it, for example, SCOTT.EMP for an object named EMP in the SCOTT schema.

4. In the Name column, scroll down to the database portlet.

5. (optional) The actions you can perform display in the Actions column next to each object. Click an action to perform tasks such as editing, compiling or granting access on the object.

Back to top