This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,876 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

Invalid EUL objects

Lalitha Subramanian
Lalitha Subramanian Member Posts: 66 Silver Badge
edited Apr 1, 2019 12:02PM in Discoverer

Hello,

We used Discoverer 10 years ago, and not longer using it after oracle de-supported.  We are still seeing some EUL4 objects in Invalid list after dropping the EUL schemas.. 

Any Ideas..

Thanks

Lalitha

Lalitha Subramanian

Best Answer

Answers

  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Mar 29, 2019 7:41AM

    Hi Lalitha,

    The most likely reason is these objects are from Scheduled Workbooks.  When a workbook is scheduled the following database objects are created:
      A view (e.g. EUL5_B011206161506Q1V1)
      A table (e.g. EUL5_B011206161506Q1R1)
      A package (e.g. EUL5_BATCH_PACKAGE011206161506 )
      A job (e.g. EUL5_BATCH_PACKAGE011206161506.RUN)

    If you are no longer using Discoverer, these objects can be removed/dropped.

    Regards,
    Sharon

    Lalitha SubramanianLalitha Subramanian
  • Lalitha Subramanian
    Lalitha Subramanian Member Posts: 66 Silver Badge
    edited Mar 29, 2019 8:15AM

    Thanks Sharon,

    Yes, Looks like there is a scheduled job that runs every month..  We also dropped the job, You mean we just need to drop these objects and will not see anymore of EUL objects? 

    EUL4_B050118165224Q1V1

    EUL4_B050118165302Q1V1

    EUL4_B050118165340Q1V1

    EUL4_B050627135621Q1V1

    EUL4_GET_ITEM_NAME

    EUL4_GET_OBJECT_NAME

    EUL4_NAMED_ELEMS

    EUL4_B050415174205Q1V1

    EUL4_B070724144604Q1V1

    EUL4_B070801152018Q1V1

    Will try that.  Thanks for your response..

    Lalitha

  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Apr 1, 2019 7:05AM Answer ✓

    Especially if they are invalid, there is zero impact.  Also, if you are not using Discoverer there is zero impact.  Yes, just drop them.

    Regards,

    Sharon

    Lalitha Subramanian