To tylko jedna z 2 stron tej notatki. Zaloguj się aby zobaczyć ten dokument.
Zobacz
całą notatkę
Validating Compiling Invalid Schema Objects
As a database administrator (DBA), you may be asked to revalidate schema objects
that have become invalid. Schema objects (such as triggers, procedures, or views)
might be invalidated when changes are made to objects on which they depend. For
example, if a PL/SQL procedure contains a query on a table and you modify table
columns that are referenced in the query, then the PL/SQL procedure becomes
invalid. You revalidate schema objects by compiling them.
You can use SQL Developer to run a report that finds invalid schema objects.
To find invalid schema objects:
1. Click the Reports tab to the right of the Connections navigator in SQL Developer.
The Reports navigator appears.
2. Expand the All Reports node, then expand the Data Dictionary Reports node, then
expand the All Objects node, and then click Invalid Objects.
The Select Connection dialog box appears.
3. In the Select Connection dialog box, select the connection to use, or create a new
connection.
If you want the invalid objects report to include information about only the invalid
objects in your own schema, use a connection for your own schema.
If you want the invalid objects report to include information about invalid objects
throughout the database, use a connection for a privileged user, such as SYS. In
this example, the connection chosen is for the SYS user.
4. Click OK.
The Enter Bind Values dialog box appears.
5. Click Apply.
The Invalid Objects tab appears in the object pane. This tab lists the invalid objects
in your schema or in the database (depending on the connection you specified in
the Select Connection dialog box).
6. When you right-click the row for a particular invalid object on the Invalid Objects
tab, the Compile option appears. Select that option to recompile the invalid object.
... zobacz całą notatkę
Komentarze użytkowników (0)