80015

80015



Validating Compiling lnvalid Schema Objects

As a database administrator (DBA), you may bc asked to revalidate schcma objccts that have becomc invalid. Schcma objects (such as triggers, proccdurcs, or vicws) might bc invalidatcd when changcs arc madc to objccts on which thcy dcpcnd. For cxamplc, if a PL/SQL procedurę eon tai ns a query on a tablc and you modify table columns that arc refcrcnccd in the query, then the PL/SQL procedurę becomes invalid. You revalidate schema objects by compiling them.

You can usc 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 Ali Reports nodc, then expand the Data Dictionary Reports node, then expand the Ali 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. orereate 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, usc a connection for a privilcged user, such as SYS. In this example, the connection chosen is for the SYS user.

4.    Click OK.

The Enter Bind Valucs dialog box appears.

5.    Click Apply.

The Invalid Objects tab appears in the object panc. This tab lists the invalid objccts in your schcma 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.



Wyszukiwarka

Podobne podstrony:
How to Convert File Systems As a systems administrator, you may be asked to convert an existing volu
Granting Access to EM Express for Nonadministrative Users As a databasc administrator, you can log i
Administrator Guidelines for Password Security Database administrators should use the following guid
Common Oracle DBA Tasks As an Oracle DBA. you can expeci to be involved in the fol łowi ng tasks: ■I
>STUDENTA 3 mimites PART ONE la tbis part of the examination you will be asked to fmd out as much
Naming Schema Objects Every object in the database belongs to one schema and has a unique name withi
- 9 - 2.04    As an admini8trative public enterprise, IHRAN is under the tutelle 
a) schemat form prawnych działania administracji publicznej Na podstawie: K. Ziemski, Indywidualny a
About SQL Developer Oracle SQL Dcveloper is a graphical version of SQL*Plus that givcs databasc admi
About This Guide Oracle Database 2 Day DBA is a databasc administration quick start guide that tcach
leftbeh Encapsulating Variatlon Objects as Arguments Should Communlcation be Encapsulated 
Laboratorium administracji ORACLE DATABASE 12c (v8) Dokumentacja Oradei2c: Database Administrator^ G
f14 11 MFC AppWizard - Step 2 of 6EJ What database support would you like to include? <• fignĄ Hę
00163 8bd8ef6e7bb29535cb91c8bcb2b620 164 McWilliams Constrained Optimization As discussed in the i
00254 07cc71dc7c8b6b356c430eda738c59e 256 Yander Wiel ARLs for large shifts. As with CUSUM schemes,

więcej podobnych podstron