Database Administration (MOSC)

MOSC Banner

Missing objects and DDL to create them

edited Jun 1, 2017 5:02AM in Database Administration (MOSC) 4 commentsAnswered

Hi Team,

I need a help from you.

We have the below objects present in our 2 of the environments. Below are the details regarding them:

PRODUCTION:

SQL> select count(*),object_type from dba_objects where owner like 'ECMCATALOG' group by object_type;

  COUNT(*) OBJECT_TYPE

---------- -------------------

       340 INDEX PARTITION

       194 SEQUENCE

       106 TABLE PARTITION

        49 PROCEDURE

       164 LOB

         2 PACKAGE

        71 TRIGGER

       466 TABLE

       813 INDEX

         5 FUNCTION

         6 VIEW

        10 TYPE

12 rows selected.

TEST:

SQL> select count(*),object_type from dba_objects where owner like 'ECMCATALOG' group by object_type;

  COUNT(*) OBJECT_TYPE

---------- -------------------

       390 INDEX PARTITION

       194 SEQUENCE

       106 TABLE PARTITION

        49 PROCEDURE

       170 LOB

         2 PACKAGE

        71 TRIGGER

       477 TABLE

       826 INDEX

         5 FUNCTION

         7 VIEW

        10 TYPE

12 rows selected.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center