Missing objects and DDL to create them
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.