Checking Invalid Objects

Moderator: NorbertKrupa

Post Reply
justin0y
Newbie
Newbie
Posts: 1
Joined: Tue Jun 21, 2016 2:28 am

Checking Invalid Objects

Post by justin0y » Thu Jul 19, 2018 10:33 am

Good Day,

I just wanted to ask since I am not very familiar with Vertica.

Is there a similar feature or a way to check for invalid objects in Vertica just like in Oracle?

"Whenever an oracle object is marked as invalid because of a table, that has been changed, the Oracle professional can change the object to valid by using a SQL*Plus script.

This script will search the Oracle data dictionary for invalid objects, create a spool file with the names of the invalid objects, then invoke a script to re-compile all of these invalid objects. The following script should be used whenever a change is made to an Oracle table or index, or any other Oracle object, since the DBA must ensure that all objects are valid and executable."

Thank you for your assistance.

Post Reply

Return to “Vertica Database Administration”