Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2014
    Posts
    3

    Red face Unanswered: SYSTP TYPES in Oracle

    SYSTP TYPES in Oracle

    I am working on Oracle 10g Database. Here for some reason i am seeing lot of SYSTP TYPES are created in my Schema. I figure out the reason that COLLECT function is creating them. Now is there any way i can do some Auditing through which I can check which SQL qureies are creating them, so that i can ask business users to not run those queries or atleast i have insight how they are getting created.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    This is a known issue with collect (bug 4033868) and is not fixed until Oracle 11.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •