UTLRP.SQL RECOMPILAR OBJECT INVALIDOS

SQL> select owner,object_name from dba_objects where status='INVALID';

no rows selected

SQL> 

> 1

[oracle@localhost admin]$ pwd

/u01/app/oracle/product/12.1.0/db_1/rdbms/admin

[oracle@localhost admin]$ cd

[oracle@localhost ~]$ cd $ORACLE_HOME/rdbms/admin

[oracle@localhost admin]$ ls -ltr utlrp.sql

-rw-r--r--. 1 oracle oinstall 3221 Aug 15  2003 utlrp.sql

[oracle@localhost admin]$ 

SQL*Plus: Release 12.1.0.1.0 Production on Tue Jun 2 19:28:24 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> start utlrp.sql