WbDbObjects

Command WbDbObjects

Command WbDbObjects shows invalid database objects, disabled indexes and constraints and broken user jobs.

Furthermore you can

• recompile all invalid objects
• make grants for a specific user
• make synonyms for a specific user

Note: This Command is currently only available for Oracle databases.

Samples

    -- shows invalid database objects, disabled indexes and constraints and broken user jobs
    WbDbObjects;

    -- shows all possible parameters
    WbDbObjects -help;

    -- compile all invalid objects
    WbDbObjects -compileInvalidObjects;

    -- make grants and synonyms for all objects of DB-User OWNER_USER for DB-User SYNONYM_USER
    WbDbObjects -makeSyn
                -makeGrants
                -userDest=SYNONYM_USER
                -profDestUser=WB_CONNECTION_PROFILE
                -userOwner=OWNER_USER;

Screenshots