Re: ORA-21779 and solution; seeking root cause analysis
Date: Wed, 25 Mar 2009 12:36:17 -0700 (PDT)
Thank you very much. Based on what you said, I found this in Data Cartridge Developer's Guide: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14289/dcitblfns.htm#i1005159 That page doesn't have the word "duration" but has "anydataset", "transient", "type".
It's odd that SMON sometimes can't drop them but we can.
- On Wed, 3/25/09, Kurt Franke <Kurt-Franke_at_web.de> wrote:
when selecting from a table function which has return type
ANYDATASET oracle creates dynamically a type object
which matches the actual return type.
and sql will cast it automatically to this actual return type, no ANYDATASET output is returned by the select. this mechanism is introduced with oracle 10
in general the smon should cleanup those types
except for the fact the time when the cleanup occures seems to be less predictable I never had problems with it when I played around with some self written tablefunctions returning ANYDATASET in oracle 10.2
you may select those system generated types with
WHERE type_name LIKE 'SYS%=='
AND length(type_name) = 29;
if no another solution is possible you may create an own
cleanup job which drops those types
before the smon try to do this - an age less than a day may be a value for a try
http://www.freelists.org/webpage/oracle-l Received on Wed Mar 25 2009 - 14:36:17 CDT