Oracle9i List of Bugs Fixed
Release 2 (9.2.0.8) Patch Set 7
 
 

Oracle9i

List of Bugs Fixed

Release 2 (9.2.0.8) Patch Set 7

June 2006

This document lists the generic bugs fixed in the Oracle9i Release (9.2.0.8) Patch Set 7 and all previous Oracle9i Release 2 patch sets. Fixed platform-specific bugs are listed in the Oracle9i Patch Set Notes Release 2 (9.2.0.8) Patch Set 7 for each platform. This document contains the following sections:

1 Patch Set Documentation

There are two documents related to this release of the Oracle9i Release 2 patch set:

The List of Bugs Fixed is a list of all generic bugs related to Oracle9i that have been fixed in this release.

Both of these documents are included with the patch set. The Oracle9i List of Bugs Fixed is also available on OracleMetalink, from document 189908.1, ALERT: Oracle9i Release 2 (9.2) Support Status and Alerts at: 

http://metalink.oracle.com

To locate document 189908.1:

  1. Log on to OracleMetalink.

  2. Click Advanced at the top of the OracleMetalink page.

  3. Enter 189908.1 in the Document ID field, then click Submit.

2 Bugs Fixed in this Patch Set by Category

This section describes the bugs fixed in this patch set by category. It includes the following categories:


Note:

This list of fixed bugs was current at the time that the patch set was released. Information about these fixed bugs may be revised after release of the patch set. Refer to the Patch Set section of OracleMetaLink document 189908.1 for any postrelease updates.

2.1 Oracle Server

The following list bugs for the Oracle Server product.

2.1.1 ANSI Joins

The following table lists the ANSI Joins bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3466980 ORA-942 / wrong results compiling views with ansi-joins as user other than the view owner
9.2.0.8 3986388 OERI:qcsalcd1 using ANSI join/s with pipelined function/s
9.2.0.8 4096288 Dump (nsoexc) parsing ANSI outer join with functional indexes
9.2.0.8 4216065 SQL query using ANSI outer join may get poor execution plan / wrong results
9.2.0.8 4369235 ANSI joins may fail with ORA-1445
9.2.0.7 3136807 Wrong results querying against snapshots with ANSI outer join
9.2.0.7 3228560 OERI[qkebValidateOpn:2] / dump under qkngbAllocate from FULL OUTER JOIN
9.2.0.7 3584515 Wrong results when ANSI syntax does not trap ambiguous column with ORA-918
9.2.0.7 3668084 Wrong results from nested FULL OUTER JOIN
9.2.0.7 3730394 Dump (qerixGetKey) from ANSI SQL with HAVING clause which uses a subquery
9.2.0.7 4078970 ORA-907 using nested FULL OUTER JOIN in PLSQL
9.2.0.6 2504168 Wrong results from query with ANSI outer join syntax and constant predicate
9.2.0.6 2618400 ORA-907 using ANSI JOIN with FROM clause subqueries
9.2.0.6 2711993 ANSI join with a set query block may produce wrong results
9.2.0.6 2846640 Ambiguous columns not signalled with ANSI join syntax (wrong results instead of error)
9.2.0.6 3087290 OERI[qcscpqbc1] possible from ANSI join
9.2.0.6 3089870 OERI[qcstxswrite1] with full outer join
9.2.0.6 3264527 OERI[12310] on SELECT with LEFT OUTER JOIN
9.2.0.6 3545642 Wrong result when using LEFT OUTER joins and TABLE() operator
9.2.0.6 3632885 In FULL OUTER JOIN a NESTED LOOPS ANTI is used when unique index exists
9.2.0.6 3696879 Wrong results from ANSI query with subquery in the ON condition
9.2.0.6 3786302 ANSI join with correlated TABLE() clause fails (ORA-904)
9.2.0.5 2354702 ANSI FULL JOIN may fail unexpectedly with ORA-942
9.2.0.5 2380549 Dump from ANSI JOIN with FUNCTIONAL INDEX
9.2.0.5 2491619 ORA-1799 not always signalled with ANSI OUTER JOIN syntax
9.2.0.5 2528839 Dump possible using ANSI OUTER JOIN with multiple subqueries
9.2.0.5 2742863 Dump (evaopn2) possible using ANSI join
9.2.0.5 2800139 Create MATERIALIZED VIEW may fail with ORA-904 using ANSI join
9.2.0.5 2800162 Query rewrite does not always work when using ANSI join in an MVIEW
9.2.0.5 2865031 Create materialized view on ANSI self-joined table fails with ORA-904
9.2.0.5 2874440 Dump (qercostart) using ROWNUM with a full outer join
9.2.0.5 2953113 ORA-928 when star_transformation_enabled=true for an ANSI query
9.2.0.5 3042674 Wrong results on ANSI object queries / XDB "extract" operations may dump (evaopn2)
9.2.0.5 3119276 ORA-942 using ANSI full join with another users view
9.2.0.5 3151888 Dump possible using ANSI JOIN with FUNCTIONAL INDEX
9.2.0.5 3171143 Wrong results from ANSI outer join with IS NULL predicate
9.2.0.4 2717694 FROM-clause subqueries using ANSI OUTER JOIN can fail with ORA-1792
9.2.0.4 2829723 Wrong results from ANSI OUTER JOIN when join condition does not reference both sides
9.2.0.4 2843541 FULL JOIN with set operator may dump (eg: UNION)
9.2.0.3 2315444 Dump from query with LATERAL view
9.2.0.3 2458655 OERI[QCTCTE1] from FULL OUTER JOIN with BIND variable in subquery
9.2.0.3 2656627 Wrong results from ANSI OUTER JOIN with CONSTANT predicates in ON clause
9.2.0.3 2670901 ORA-604 / ORA-907 / ORA-904 from WITH clause with ANSI join in it
9.2.0.2 2245372 ORA-904 possible from TABLE.* in SELECT list from ANSI join query
9.2.0.2 2338661 Wrong results possible from ANSI outer join
9.2.0.2 2352928 Wrong results / dump from FULL OUTER JOIN to SUBQUERY with GROUP BY
9.2.0.2 2357784 OERI[QCTCTE1] parsing ANSI OUTER JOIN with a VIEW with a SET operation (eg: UNION ALL)
9.2.0.2 2360043 LEFT OUTER JOIN may produce incorrect results instead of ORA-1799
9.2.0.2 2370324 False ORA-904 possible on NATURAL RIGHT JOIN of different schema tables
9.2.0.2 2388008 Wrong results from ANSI outer join with 'const <relop> col'

2.1.2 ASSM Space Management (Bitmap Managed Segments)

The following table lists the ASSM Space Management (Bitmap Managed Segments) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2104780 ORA-4000 specifying PCTFREE when creating table in ASSM
9.2.0.8 3219117 LOB SEGMENT uses more space with ASSM
9.2.0.8 3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
9.2.0.8 3610777 Excessive CPU from INDEX insert into ASSM index segment
9.2.0.8 3857781 ASSM tablespace index branch split/relocate generates huge amount of undo
9.2.0.8 4055596 TRUNCATE of an auto space managed table with an index sets index block count wrong
9.2.0.8 4067168 Poor table scan PQ performance possible for ASSM segments
9.2.0.8 4188324 Wasted space possible in ASSM segments
9.2.0.8 4207520 DBMS_SPACE.SPACE_USAGE gives wrong results for ASSM LOB segment
9.2.0.8 4254666 LOB space in ASSM tablespace not reused effectively
9.2.0.8 4288876 Excessive redo / undo generation from insert/update with ASSM indexes
9.2.0.8 4464828 OERI[kcbgtcr_12] using ANALYZE on ASSM segment
9.2.0.8 4475314 DELETE then INSERT without commit on ASSM segment can be slow
9.2.0.8 4517470 Table corruption with RAC when ASSM managed and truncate used
9.2.0.8 4694312 Index inserts to ASSM segments can be slow
9.2.0.8 4887955 Unnecessary extent allocated in locally managed ASSM tablespace in RAC
9.2.0.7 3894096 + Poor MView refresh performance in ASSM tablespaces
9.2.0.7 3849938 DBMS_SPACE.UNUSED_SPACE returns wrong block_id for last extent used
9.2.0.7 3868753 Concurrent export / INSERT of ASSM segment can fail with ORA-1410 / ORA-8103
9.2.0.7 4052219 LOB segment may leak space when ASSM managed
9.2.0.7 4069484 ASSM segments waste space with heavy concurrent inserts
9.2.0.7 4074953 Insert performance problems with ASSM in RAC environments
9.2.0.7 4121673 DBMS_SPACE_ADMIN.assm_segment_verify does not detect certain corruptions
9.2.0.7 4142932 DBA_SEGMENTS.EXTENTS wrong for locally managed segment after TRUNCATE operation
9.2.0.6 3785200 * Corruption possible in automatic space managed segments. This bug is alerted in Note:281047.1
9.2.0.6 3771668 + Poor INSERT performance with ASSM
9.2.0.6 2921895 ASSM tablespace has large initial extent size for >=16k DB_BLOCK_SIZE
9.2.0.6 3064159 Sessions using ASSM segments may leak memory
9.2.0.6 3304290 OERI[kcbgtcr_13] scanning ASSM segments if cursor invalidated
9.2.0.6 3329096 Free space may not be used in an AUTO SPACE MANAGED segment
9.2.0.6 3430832 OERI[25012] in DML after ONLINE create index against PARTITIONED table
9.2.0.6 3613078 OERI[4097] from DML on TRANSPORTED tables with ASSM
9.2.0.6 3687456 OERI[ktspgetmyb-1] / Corrupt LOB if EXTENT size not multiple of LOB CHUNK SIZE
9.2.0.5 2784201 OERI:[ktspfupdst-1] on INSERT into LOB after TRUNCATE with ASSM
9.2.0.5 2915226 Space may be wasted in index segments with ASSM
9.2.0.5 2997248 OERI[ktspfupdst-1] can occur on DML against ASSM segments
9.2.0.5 3029292 LOB corruption possible on ASSM tablespace
9.2.0.5 3085651 Table corruption / OERI after TRUNCATE on ASSM table with NESTED TABLE cols
9.2.0.5 3120807 Table growth possible using automatic segment management
9.2.0.5 3127116 OERI:kcbgcur_9 during rollback of DML in ASSM segment
9.2.0.5 3213101 Lob corruption / ORA-1555 can occur on a LOB segment in ASSM
9.2.0.5 3215579 OERI[ktspfupdst-1] / corruption after DEALLOCATE UNUSED on ASSM
9.2.0.4 2944866 * Free space in LOB table / tablespace not reused with ASSM. This bug is alerted in Note:250525.1
9.2.0.4 2559022 ORA-372 selecting from ASSM segment in READ ONLY tablespace / DB
9.2.0.4 2643723 ORA-1555 possible using AUTO space managed LOB segments
9.2.0.4 2722809 OERI:kcbgcur_9 on direct load into AUTO space managed segment
9.2.0.4 2733904 ORA-600[KTSPNEXTL1:4] after interrupted TRUNCATE with automatic space management
9.2.0.4 2917432 Free space may not be used in Auto space managed segment
9.2.0.4 2967417 OERI:KCOAPL_BLKCHK may occur using Auto managed segment
9.2.0.3 2531519 OERI:[25012] from parallel direct load of bitmap managed segments
9.2.0.3 2619867 OERI:[KCBGTCR_12] / ORA-8103 / ORA-1410 SELECTing from bitmap managed segment
9.2.0.3 2676912 OERI[KTELRWI-2] from CREATE UNIQUE INDEX with Bitmap managed segment
9.2.0.3 2685269 ASSM segment may become corrupt - OERI[ktspstchg-1] on DELETE from table/index
9.2.0.2 2212656 OERI[ktspfupdst-1] possible during DML on bitmap managed segments
9.2.0.2 2296597 RESUMABLE session may OERI:2006 with AUTOMATIC segment space management
9.2.0.2 2326066 OERI[ktspffbmb-4] creating LOB column in AUTO SEGMENT SPACE MANAGEMENT
9.2.0.2 2326948 DBV-111 using DBVERIFY SEGMENT_ID=... on a bitmap space managed segment
9.2.0.2 2477368 Full table scan of AUTO space managed table may not return all rows

2.1.3 Advanced / Secure Networking

The following table lists the Advanced / Secure Networking bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.4 2514960 SSLUnknownErr exception using HTTPS / OracleSSLCredential in JVM
9.2.0.4 2662826 Unable to connect to GLOBALLY IDENTIFIED user via SSL over OCIConnectionPool

2.1.4 Advanced Queuing

The following table lists the Advanced Queuing bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3616353 HTTP propagation does not update TOTAL_NUMBER in DBA_QUEUE_SCHEDULES
9.2.0.8 3848650 Invalid (negative) statistics in V$QUEUE
9.2.0.8 4142308 AQ queues may not fall back to primary instance in RAC
9.2.0.8 4162272 OCI-21500 from OCIDescriptorFree of OCI_DTYPE_AQMSG_PROPERTIES
9.2.0.8 4177066 dbms_aq.listen does not detect different subscriber
9.2.0.8 4330687 AQ dequeue not in FIFO order
9.2.0.8 4369410 OJMS listeners can miss receiving notifications
9.2.0.8 4519477 AQ dequeue by correlation id is extremely expensive
9.2.0.8 4527173 AQ$_JMS_TEXT_MESSAGE.SET_TEXT method does not work correctly with multi-byte character sets
9.2.0.8 4573912 ORA-24021 in DBMS_AQ_IMPORT_INTERNAL.AQ_DEFN_UPDATE on 9i import of queue
9.2.0.8 4618808 AQ operation requiring exclusive lib cache lock may hang
9.2.0.8 4730389 ORA-30757 on propagation from 10.2 -> 8i
9.2.0.7 3192364 OERI:[kwqidgpchdl: chdl] in job queue process for a buffered queue with no remote subscribers
9.2.0.7 3258674 QMN process may dump or raise an internal error during DML
9.2.0.7 3412625 DBMS_METADATA cannot handle AQ queue comments over 50 characters long
9.2.0.7 3771508 OERI[kcbgtcr_1] / OERI[25012] selecting from V$AQ in a shared server
9.2.0.7 3804515 "kwqicaclcur" writes trace file entries for ORA-1013 and ORA-3113
9.2.0.7 3830460 Prevent reporting of certain errors to AQ trace files
9.2.0.7 3830972 DBMS_AQ.LISTEN on RAC cluster may not see new enqueue messages
9.2.0.7 3930499 AQ propagation of XMLType throws OERI[kolahashfind:hash table]
9.2.0.7 3960423 AQ enqueue to large number of queues can be slow
9.2.0.7 4019844 AQ notifications triggered for rolled back messages on single consumer queues
9.2.0.7 4028364 EMN0 may hang holding library cache pin if notification recipient does not respond
9.2.0.7 4084096 utlrp.sql does not validate queues in 9.2
9.2.0.7 4098102 High CPU consumption by AQ listen
9.2.0.7 4190303 OJMS (AQ) connection is not closed with the tranasaction timeout in OC4J
9.2.0.7 4285294 Memory leak in AQ messaging
9.2.0.7 4314484 AQ Java transformations may fail to propogate with OERI:[kwqptlud:kopa]
9.2.0.6 3109964 Export 8i / import AQ queue can give ORA-24033 when enqueueing a message
9.2.0.6 3122154 AQ JMS receive(wait_time) does not return after wait_time
9.2.0.6 3148239 AQ PLSQL notification callback does not record an error when it fails
9.2.0.6 3168530 AQ order of messages may not be preserved
9.2.0.6 3195244 Dump propogating ADT messages to JMS type queue
9.2.0.6 3231814 Client may dump if AQ unregister fails and the subscription handle is freed
9.2.0.6 3237530 Intermittent ORA-25248 errors in alert file using AQ
9.2.0.6 3288732 AQ propagation can hold library cache locks longer than needed
9.2.0.6 3317029 Dump (korfpoid) / OERI[kocpnsh014] / OERI[kwqidjqp0] from AQ in RAC
9.2.0.6 3336594 High CPU use in QMON scanning DEF$ tables needlessly
9.2.0.6 3358440 AQ propagation fails with ORA-942 or OERI:16622 at the remote node
9.2.0.6 3456044 Poor AQ performance from multiple dequeuers performing rollback
9.2.0.6 3486019 Dump in kwqiclod possible using AQ
9.2.0.6 3554319 OERI[kqludp2] can occur adding a RULE to a RULESET
9.2.0.6 3588250 Do not report resignalled errors in AQ
9.2.0.6 3601748 JMS client exit leaves subscribers in AQ
9.2.0.6 3611423 PGA memory leak in AQ propagation process(J000)
9.2.0.6 3614299 Dump adding a subscriber with a rule containing literals with CURSOR_SHARING = FORCE|SIMILAR
9.2.0.6 3656306 JMS application may throw "UnsatisfiedLinkError: ociinit"
9.2.0.6 3658039 ORA-6540 / shared pool memory use from EMON during PLSQL notification
9.2.0.6 3802583 OERI:[kohcpi298] from enqueue for rule subscribers
9.2.0.5 2133320 Process may hang issuing DML against an IOT
9.2.0.5 2167574 DEQUEUE fails with OERI:kodrsobj1 when PAYLOAD is NON-FINAL object
9.2.0.5 2566043 Dump in kwqiexenq0/kwqidxdeq0 if ENQUEUE / DEQUEUE called with empty string
9.2.0.5 2598438 ORA-1722 from DBMS_AQ_SYS_IMP_INTERNAL during import of queue table/s
9.2.0.5 2659228 AQ JMS cannot get subscriber if name contains more than 20 characters
9.2.0.5 2740939 OERI[kwqidmcretry:sub-name] possible when dequeuing messages from exception queue
9.2.0.5 2840846 JMS in RAC mode fails to send message on failover
9.2.0.5 2984987 OERI[12760] when dequeuing using the Java APIwith CURSOR_SPACE_FOR_TIME
9.2.0.5 2995204 PMON may crash the instance (OERI:kwqicklem-spinf) cleaning up an aborted AQ session
9.2.0.5 2996527 AQ messages may be READY but cannot be dequeued
9.2.0.5 2997196 OJMS does not work properly on RAC failover
9.2.0.5 2997536 9i client may not get AQ notifications from 8i server
9.2.0.5 3003788 ORA-25236 can occur during AQ dequeue
9.2.0.5 3008039 Delay / expiration settings in AQ may not match the requested time
9.2.0.5 3016394 OJMS throws SQLException instead of SecurityException for invalid credentials
9.2.0.5 3033868 OERI[kwqidjqp0] from DBMS_AQADM_SYS.REGISTER_DRIVER
9.2.0.5 3041387 OERI[kopi2_readlen083] enqueuing object with immediate embedded NULL
9.2.0.5 3051582 ORA-7445 [kwqpcbk] / OERI:[kpoaqeq:kwqprc] on resuming AQ propogation to a remote database
9.2.0.5 3060261 <Queue_table>.ENQ_TIME and V$ view TIME columns may be ahead of SYSDATE
9.2.0.5 3068705 9i JMS client using OCI driver incompatible with 8i server
9.2.0.5 3105274 AQ JMS cannot dequeue text payload > 4k with UTF8 DB character set
9.2.0.5 3105912 RETRY_COUNT not set properly after DEQUEUE / ROLLBACK from OCI client
9.2.0.5 3109827 Dequeue fails for rule based subscriber after import from 817 export file
9.2.0.5 3122291 Two concurrent dequeue sessions can dequeue from same transactional group
9.2.0.5 3123030 OCISubscriptionUnregister() can fail with ORA-1435
9.2.0.5 3149159 AQ PLSQL notification callback procedures cannot use COMMIT/ROLLBACK
9.2.0.5 3151336 AQ PLSQL notification lost if notification code fails
9.2.0.5 3160246 ORA-24026 can occur while trying to add or remove a subscriber from the queue
9.2.0.5 3161240 Dump in kwqacsp using DBMS_AQADM.CREATE_QUEUE_TABLE with EVENT 10862
9.2.0.5 3185622 Expired messages delivered twice by source queue and exception queue
9.2.0.5 3217636 AQ JMS client leaks memory dequeueing from empty queue
9.2.0.5 3229958 AQ owner_instance may not fallback to primary instance
9.2.0.5 3230177 AQ JMS can truncate the payload
9.2.0.5 3230861 OERI[kwqidjqp0] / ORA-22275 propogating messages with a LOB
9.2.0.5 3258242 AQ propogation may halt in RAC
9.2.0.5 3258308 EMON may hangs and stop delivering notifications
9.2.0.5 3271271 QMON can deadlock with job queue processes
9.2.0.5 3276040 AQ propogation may dump and cannot continue
9.2.0.5 3416258 OERI[KWQICKCIDX:] possible loading queue objects
9.2.0.4 2757441 * AQ problems Upgrading AQ / Applications DB from 8i to 9i. This bug is alerted in Note:231074.1
9.2.0.4 1522211 Dequeue does not see enqueue from another RAC/OPS node for 5 minutes
9.2.0.4 2397300 CPU Spin from concurrent AQ dequeue of same message without commit/rollback
9.2.0.4 2457577 EMON does not report errors for continual network errors
9.2.0.4 2554413 Propogator only waits 30 seconds when there is no message
9.2.0.4 2579935 CREATE QUEUE fails (ORA-904) if user owns table called "ALL_RULES"
9.2.0.4 2604145 AQ objects INVALID after upgrade sequence 90->92->90->92
9.2.0.4 2614221 Dequeue from EXCEPTION queue truncates SCHEMA NAME to 8 characters
9.2.0.4 2671550 JMS getQueue() and getTopic() are slow with many queues in the DB
9.2.0.4 2722510 ORA-7445 on DEQUEUE after database upgrade from 8i
9.2.0.4 2744635 Multi-consumer DROP_QUEUE_TABLE fails if datafile inaccessible / DROP TABLESPACE fails with ORA-24008
9.2.0.4 2747605 Poor "Enqueue" performance of non-persistent queue
9.2.0.4 2781500 Dictionary corruption possible if DBMS_RULE_ADM.DROP_RULE / DROP_EVALUATION_CONTEXT errors
9.2.0.4 2798855 AQ rules views may become INVALID after upgrade to 9.2
9.2.0.4 2805491 JMS-120 / PLS-306 using older JMS client (AQAPI.JAR) to 9.2 server
9.2.0.4 2808007 AQ/JMS does not get message notifications if DB does not know HOSTNAME of client
9.2.0.4 2809130 Queue import can corrupt dictionary metadata if queue pre-exists
9.2.0.4 2841243 DBMS_AQADM.CREATE_QUEUE succeeds even if table is invalid
9.2.0.4 2857178 ORA-1000 from multi-threaded JMS client doing object enqueue/dequeue
9.2.0.4 2871030 JMS leaks a cursor for each AQOracleQueueTable
9.2.0.4 2881018 EXP/IMP of Queues after DB upgrade to 9.2 fails
9.2.0.4 2882923 ORA-1031 importing Queue table
9.2.0.4 2902091 NULL body from dequeue of LCRs as XMLType message from AQ Anydata queue
9.2.0.4 2913866 ORA-7445 [KWQAPAQN] when EVENT 10862 is set
9.2.0.4 2916802 "java.lang.UnsatisfiedLinkError: aqxmlinit" from AQ XML servlet using OC4J
9.2.0.4 2949941 Rules engine objects may become invalid after upgrade
9.2.0.4 2951352 No way to cancel a blocking OJMS dequeue with JDBC Thick
9.2.0.3 2381172 + IMPORT fails / corrupts the AQ dictionary with duplicate QUEUE_TABLE names
9.2.0.3 2045940 AQ SECURITY incompatible with definer/invoker's rights packages
9.2.0.3 2298215 AQ dequeue can intermittently take seconds to dequeue
9.2.0.3 2370520 EMON hang - message notifications not delivered
9.2.0.3 2486477 "buffer busy waits" on very active Queue table (IOT)
9.2.0.3 2490090 Propogation stops if queues are recreated and enqueuing session does not reconnect
9.2.0.3 2497219 OERI:[17065] / OERI:[17064] from XAOROLLBACK with AQ in OPS/RAC
9.2.0.3 2543395 RETRY_COUNT not incremented when DEQUEUEING session dies
9.2.0.3 2573516 When DEQUEUE rolled back other sessions do not see the message immediately
9.2.0.3 2598124 EXP-8 / ORA-1422 if queue and queue table have same name
9.2.0.2 2395193 * OERI:4414 / ORA-1403 on dequeue of pre-9.2 enqueued messages. This bug is alerted in Note:200983.1
9.2.0.2 2131687 ORA-604 / ORA-1001 querying V$AQ / X$KWQSI
9.2.0.2 2145198 AQ event notifications may not be delivered / QMN does not free connection descriptors
9.2.0.2 2200934 PMON may crash in kssxdl cleaning up session which was enqueuing a message
9.2.0.2 2200961 OERI:[529] in PMON after session dies when adding a subscriber
9.2.0.2 2221168 Orphan messages possible after remote subscriber removed
9.2.0.2 2249786 IMP-17 / ORA-24150 possible importing user RULE SET
9.2.0.2 2265794 Dequeue with next message navigation may get ORA-1555
9.2.0.2 2272964 QMN may die with OERI:[KWQITNMPTME:WAIT] when dequeue by message ID
9.2.0.2 2273354 AQ/JMS message notifications may not be received
9.2.0.2 2277283 Only SYS can register Connection Factories using JDBC (or PLS-201 thrown)
9.2.0.2 2286290 ALTER TABLE MOVE should not be allowed for Queue tables
9.2.0.2 2349021 ADT LOB dequeue may dump in multithreaded client
9.2.0.2 2349883 OERI:[kwqpaspse2c: invalid status] after interrupted DBMS_AQADM.UNSCHEDULE_PROPAGATION
9.2.0.2 2364533 ClassLoaderException possible using OJMS in OC4J EJB
9.2.0.2 2372052 OJMS does not support multiple JMS connections in JDBC Thin
9.2.0.2 2372422 OJMS throws NullPointerException with NULL payload enqueued using JDBC THIN
9.2.0.2 2373192 OERI[KOPE2_WRITES118] on AQ propogations between different character set databases
9.2.0.2 2384580 OJMS fails to remove a durable subscriber in compliant mode
9.2.0.2 2390435 OJMS close() rolls back current global transaction
9.2.0.2 2398517 OERI:KOPE2PIC661 and similar on AQ propogation between different Oracle versions
9.2.0.2 2402677 ENH: Add JDBC thin OJMS support for all JMS message types on single destination
9.2.0.2 2402690 ENH: Add JDBC thin OJMS support for all JMS message types on single destination
9.2.0.2 2405004 PROPAGATION from TYPED QUEUE to AnyData queue fails
9.2.0.2 2409601 OERI[!QSCHEMA] from DBMS_AQADM.VERIFY_QUEUE_TYPES if queue name does not include SCHEMA
9.2.0.2 2424746 Unexpected ORA-24033 enqueuing an AQ message after upgrade to 9.2
9.2.0.2 2458956 OJMS AQjmsException enqueuing javax.jms.BytesMessage > 2000 bytes
9.2.0.2 2483854 ORA-7445 [kwqppreaqe] with >10 remote subscribers to a queue

2.1.5 Analytic SQL (Windowing etc..)

The following table lists the Analytic SQL (Windowing etc..) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3593345 INSERT AS SELECT with UNION may dump if using CASE
9.2.0.8 3669229 OERI[kkqsrre:4] from group_id() in query rewrite
9.2.0.8 3760380 NULL value for ROWNUM when using an OVER WINDOWING clause
9.2.0.8 3855374 Dump (qcpircx) parsing SQL which uses WINDOW operations
9.2.0.8 4573980 Dump in qeesTraverseExpr using a GROUPING operator in a GROUP BY clause
9.2.0.7 2718235 Dump (evacnt) when query uses WINDOW NOSORT over an aggregation
9.2.0.7 3083373 ORA-905 when using an analytic clause in SQL within PLSQL
9.2.0.7 3270444 OERI[msqopnws.gsets1] for GROUPING SET queries with correlated variables
9.2.0.7 3684796 ORA-904 when explaining GROUPING SETS query with fine grained auditing
9.2.0.7 3738557 SELECT with 2 LAG operations dumps (qkswcColRefWqbc)
9.2.0.7 3753308 NLS_SORT not applied implicitly to window functions
9.2.0.7 3854478 ORA-935 executing SQL with analytic functions over a database link
9.2.0.7 3859671 OERI [qctginf : opncsfrm] on INSERT AS SELECT with a window function
9.2.0.7 4006711 GROUPING SET SQL may return fewer rows than expected
9.2.0.6 2510971 PERCENTILE_CONT() can produce wrong results with an ORDER BY
9.2.0.6 2616719 OERI[kkojocol:2] using GROUPING SETS with STAR TRANSFORMATION
9.2.0.6 2783416 OERI[qkaorderbypd 3] selecting ROWNUM with a WINDOW sort in parallel
9.2.0.6 2864055 Wrong results using DISTINCT in inline view using analytic functions
9.2.0.6 2921612 Query with anti/semi join against a partitioned table can give wrong results
9.2.0.6 3092006 OERI[kkqwrm_noref: colfdnf set] from "WITH" select using WINDOW functions
9.2.0.6 3096575 Wrong results for queries using RANK() with ORDER BY ascending
9.2.0.6 3187502 Wrong results from SQL with HAVING GROUPING
9.2.0.6 3241919 Analytic functions may dump in parallel
9.2.0.6 3294293 OERI[12455],[pti:qkaqkn] on SELECT FOR UPDATE of partitioned table with WINDOW functions
9.2.0.6 3329128 Wrong results from SQL with GROUPING SETS and IS [NOT] NULL
9.2.0.6 3348585 Dump (in LNXMIN) using WINDOW functions with CASE/DECODE
9.2.0.6 3355043 The MIN analytic returns bad data when selecting from nested collection type
9.2.0.6 3492949 Dump (qxuag_val2workarea) from select using user aggregate function
9.2.0.6 3510094 Use of an analytic function skews the result from CONTEXT indextype SCORE operator
9.2.0.6 3533428 ORA-904 SYS_TBL$3$.ID running query with GROUP BY CUBE and CONNECT BY
9.2.0.6 3582445 Predicate on PARTITION BY clause of WINDOW function not pushed into view
9.2.0.6 3607226 No predicate pushing into UNION ALL view with analytic function/s
9.2.0.5 2692500 GROUP BY with ROLLUP / CUBE may return no rollup rows
9.2.0.5 2842163 OERI[qkainitgrpfns.3] for query with GROUPING() and NULLS FIRST
9.2.0.5 2913155 Dump in kkojnp for SQL with WINDOW function and no ORDER BY
9.2.0.5 3015947 ORA-1790 can occur in queries using the SYS_OP_PAR() function
9.2.0.4 2688053 Wrong results using GROUPING SETS
9.2.0.4 2744760 Unexpected ORA-604/ORA-904 possible using GROUPING SETS clause
9.2.0.4 2773831 Wrong results possible from GROUPING SETS with OUTER JOIN
9.2.0.4 2791967 ORA-7445 [EVAFSTLST] possible using DENSE_RANK with FIRST/LAST function
9.2.0.4 2836690 ROLLUP over DBLINK may fail with OERI:qks3tinit
9.2.0.4 2861866 Wrong results from STAR transformation with WINDOW functions
9.2.0.4 2910437 Inefficient plans on rewrite of SQL with GROUPING SETS and CASE expressions
9.2.0.4 2928676 CREATE MVIEW using LAG with PARTITION clause may spin in JA16SJIS
9.2.0.4 2939697 ORA-7445 [qerwnWriteToDisk] using duplicate analytic window functions
9.2.0.4 2953931 ORA-4031 parsing query with numerous groupings
9.2.0.3 2507421 OERI:[kkqwrm_noref: COLFDNF set] possible from WINDOW function and WITH clause
9.2.0.3 2708898 STAR_TRANSFORMATION with a WINDOW function may dump (evaopn2)
9.2.0.3 2767539 Dump (in qerpxStart) possible from TEMP TABLE TRANSFORMATION with WINDOW function
9.2.0.2 2176103 OERI:[KKQSRRE-1] on query rewrite with FIRST / LAST & aggregate
9.2.0.2 2331475 OERI:[qkaSplitOGs.2] possible from COUNT(*) with window functions.
9.2.0.2 2443764 Simple CASE expressions much slower than DECODE equivalent
9.2.0.2 2482089 GROUPING SET QUERY gives wrong results on Query REWRITE
9.2.0.2 2483794 ORA-7445[NSOINP] using GROUPING SETS with SUBQUERY

2.1.6 Application Context

The following table lists the Application Context bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3320402 Single byte memory corruption (\0) from SYS_CONTEXT
9.2.0.7 3277927 Unexpected ORA-2070 possible when using a SYS_CONTEXT function
9.2.0.6 3306667 Wrong length possible for value from SYS_CONTEXT()
9.2.0.6 3570286 OERI[733] from high use of application context (DBMS_SESSION.SET_CONTEXT)
9.2.0.5 3157697 SYS_CONTEXT is not evaluated at primary site when used over a database link
9.2.0.4 2595839 ORA-2070 can occur using SYS_CONTEXT in an RLS policy function
9.2.0.4 2635664 VPD policy groups may not respond to the driving application context
9.2.0.4 2685869 Wrong results using PQO with OLS/VPD which uses application context
9.2.0.4 2882484 DROP evaluation context FORCE does not invalidate dependents - dumps / OERI possible
9.2.0.3 2435725 APPLICATION CONTEXT attribute visible after dropping the NAMESPACE

2.1.7 Bitmap Indexes

The following table lists the Bitmap Indexes bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2944274 DBMS_METADATA does not handle bitmap join indexes
9.2.0.8 3026986 Dump (kkpouoe_update_obj_entries) dropping a FAKE bitmap index
9.2.0.8 3219917 OERI:20083 a DOMAIN index in a rowid-to-bitmap conversion
9.2.0.8 3389359 OERI[12700] from invalid BITMAP OR in execution plan
9.2.0.8 3827085 Dump from multi-column inlist with bitmap join index
9.2.0.8 3929301 ORA-14642 on exchange partition
9.2.0.8 4350208 PGA memory leak associated with bitmap indexes
9.2.0.8 4421063 Exchange partition fails with ORA-14098 with 2 or more bitmap join indexes
9.2.0.8 4533389 ANALYZE INDEX VALIDATE STRUCTURE does not update INDEX_STATS for bitmap indexes
9.2.0.8 4695511 OERI[kxfqupp_bad_cvl] when creating bitmap index
9.2.0.8 4697632 OERI[atbbjie2] from exchange partition with bitmap join indexes
9.2.0.8 5015557 Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index
9.2.0.8 5078743 Dump (in qkabxo) using bitmap access path in FIRST K ROWS
9.2.0.7 3183084 Performance hit / OERI for index maintenance if TEMPORARY blocksize < index blocksize
9.2.0.7 3617574 Transport of bitmap index gives errors at transported to site
9.2.0.7 3747472 ORA-14642 on EXCHANGE PARTITION INCLUDING INDEXES
9.2.0.7 3823550 False ORA-1499 validating a table CASCADE ONLINE with a bitmap index
9.2.0.7 3854034 OERI[733] optimizing SQL using bitmap indexes
9.2.0.7 3867374 Zero cost possible for nested loops access to table with single bitmap semijoin
9.2.0.7 3938376 OERI[15160] accessing via a bitmap join index
9.2.0.7 4109971 Wrong results using IOT and bitmap index
9.2.0.6 3293688 OERI[504] / OERI[510] using bitmap indexes with shared servers
9.2.0.6 3358065 Dump (kkoiop) using bitmap join index
9.2.0.6 3515018 Dump (in msqopnws) on SELECT DISTINCT with PARALLEL BITMAP INDEX
9.2.0.6 3622875 False ORA-1499 from ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE
9.2.0.6 3658974 OERI:12455 from parallel DML with bitmap index
9.2.0.6 3695271 Dump (kkojije) with bitmap index and multi column inlist
9.2.0.5 2093670 OERI:12700 / BITMAP index corruption possible
9.2.0.5 2870079 Create Bitmap index skipped at logical STANDBY site
9.2.0.5 2977553 OERI [kdibcoappend:pagap] from ALTER INDEX REBUILD of a bitmap index
9.2.0.5 2999894 OERI:6032 / corrupt index creating a bitmap index on a compressed tables with bitmap indexes
9.2.0.5 3010012 Dump modifying constraints which BITMAP JOIN INDEX relies on
9.2.0.5 3048661 Create bitmap index can use more CPU than needed if more memory available
9.2.0.5 3145991 Bitmap index corruption possible (rare)
9.2.0.4 2697589 OERI:[kdiblbout:rowidIllegal] on INSERT into IOT with BITMAP indexes
9.2.0.4 2705892 ORA-7445[qesaPackCols] using functional bitmap indexes
9.2.0.4 2747052 Wrong results from queries with bitmap index access with large OR-chains
9.2.0.4 2767505 OERI[KDISLE:NROWS] possible on DELETE from table with BITMAP index
9.2.0.4 2803588 OERI[20083] using DBMS_STATS.GATHER_TABLE_STATS on table with bitmapped functional index
9.2.0.3 2451259 ORA-28604 on recreate of BITMAP index on COMPRESSED table
9.2.0.3 2536531 MERGE on table with BITMAP index fails with OERI:[kauins:1]
9.2.0.3 2556294 ORA-7445[kkocfcc] possible using Bitmap Join Index
9.2.0.3 2569154 Wrong results from PQ with NL of BITMAP INDEX with ROWID predicate
9.2.0.2 2134836 OIERI:QKABRIX1 possible with BITMAP and PARTITIONED index on NON-PARTITIONED table
9.2.0.2 2156961 OERI:20040 possible from bitmap index
9.2.0.2 2286794 Dump in evaopn2 if STAR transformation FACT table has >1 bitmap index on a join column
9.2.0.2 2293722 ORA-7445 [evaopn2] possible using BITMAP JOIN INDEX with may NULLs
9.2.0.2 2364585 STAR transformation may dump (EVAOPN2) if fact column is leading prefix of bitmap index

2.1.8 Change Data Capture

The following table lists the Change Data Capture bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 4285404 Streams propogation from 9.2 -> 10.2 gets ORA-25334 / ORA-25292
9.2.0.7 4051461 Cannot create change tables on logical standby system
9.2.0.6 3064971 ORA-54 when running DBMS_LOGMNR_CDC_PUBLISH.PURGE / change table keeps growing
9.2.0.6 3838121 Dump calling dbms_cdc_subscribe.subscribe()
9.2.0.5 2899668 LPX-217 from DBMS_REDEFINITION.START_REDEF_TABLE on UTF8 database
9.2.0.5 3051801 ORA-6502 from EXPORT if CDC returns a long string
9.2.0.4 2802515 ORA-31496 on DROP USER CASCADE on CDC publisher
9.2.0.3 2362606 DBMS_CDC_PUBLISH.PURGE does not purge the change table
9.2.0.2 2205649 ORA-29531 from DBMS_LOGMNR_CDC_PUBLISH.DROP_SUBSCRIBER_VIEW
9.2.0.2 2338739 DBMS_LOGMNR_CDC_PUBLISH / DBMS_CDC_PUBLISH may error with ORA-1426

2.1.9 Cluster Ready Services / Parallel Server Management

The following table lists the Cluster Ready Services / Parallel Server Management bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 4537790 P Windows: After reboot CRS startup can be slow

2.1.10 Code Improvement

The following table lists the Code Improvement bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3995396 Diagnostic enhancement to help try to detect memory corruptions
9.2.0.8 4053888 ORA-1499 diagnostic trace does not dump REDO for the table block
9.2.0.8 4067168 Poor table scan PQ performance possible for ASSM segments
9.2.0.8 4183830 Enhancement to diagnostic dump routine (add ksxpdmp)
9.2.0.8 4307033 Multi-column partition pruning needs leading columns
9.2.0.8 4320012 Enhancement - Add support for Albania and Albanian in NLS
9.2.0.8 4339128 Heavy latch contention from queries against library cache views
9.2.0.8 4669305 Enhancement: Add diagnostics for OERI[12333]
9.2.0.7 2720661 CBO enhancement to break tie based on NDK when cost is same
9.2.0.7 3264021 New DBMS_LDAP interface needed for large binary attributes
9.2.0.7 3493017 Enhanced diagnostics for active transaction count maintenance
9.2.0.7 3697152 Diagnostic to dump memory when a bad KGHU magic number is seen
9.2.0.7 3747032 Enhancement: Ensure CATALOG/CATPROC are run as SYS
9.2.0.7 3881099 ORA-1280 diagnostic enhancement
9.2.0.7 3903913 Streams spill data hard to decode
9.2.0.7 3906687 Diagnostic enhancement for latch wait scenarios
9.2.0.7 3991417 Diagnostic enhancement - add KGHU checking event 10509
9.2.0.7 4028979 Add support for codepoint semantics in shared-cursors
9.2.0.7 4072376 Enhancement: Write diagnostics for block change callback errors
9.2.0.7 4110284 Enhanced diagnostics for send timeout problems
9.2.0.7 4122045 Enhanced diagnostic for kghfrmrg errors
9.2.0.7 4131045 Add DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY
9.2.0.6 3566945 + ENH: No block level locking for externally co-ordinated prepared transactions
9.2.0.6 3130972 ENH: Allow over 1Gb private memory in realfree allocator
9.2.0.6 3316345 ENH: Enhance checks on interconnect blocks by a check for the correct DBA
9.2.0.6 3457571 Enhancement to DBV to show highest SCN in a file / show blocks above an SCN
9.2.0.6 3795329 Stack trace unwind is slow on some platforms
9.2.0.6 3797523 Enhancement - Include stack information in systemstate dumps
9.2.0.6 3868840 _DB_BLOCK_CACHE_PROTECT has high overhead
9.2.0.5 3024309 ENH: Allow FAST REFRESH of MVIEW after MOVE of tables/logs
9.2.0.5 3189374 ENH: Additional diagnostics for library_cache dumps
9.2.0.5 3258738 ENH: Add characterset EL8EBCDIC423R
9.2.0.5 3271907 ENH: Extra diagnostic information if RAC sees a fractured controlfile block
9.2.0.5 3282294 ENH: Extra trace information for ORA-26688
9.2.0.5 3293155 ENH: Diagnostic enhancement to help investigate memory corruptions/leaks
9.2.0.5 3310746 ENH: Additional trace and diagnostics for ORA-4031 errors
9.2.0.5 3316003 Internal change to help avoid ORA-4031 for multi-subpool SGAs
9.2.0.5 3316453 "_dbwr_trace"=1 can be slow
9.2.0.4 2602197 ENH: XDB should support LDAP groups within ACLs
9.2.0.4 2782926 Diagnostic for when PMON cannot get ROW CACHE enqueue
9.2.0.4 2784301 ENH: Add support for OCCI in Visual C++ V7
9.2.0.4 2799028 ENH: Remove Functional Index need for QUERY_REWRITE / QUERY_REWRITE_ENABLED
9.2.0.4 2801367 Diagnostic fix to dump more information on OERI:[skgxprrgn2]
9.2.0.4 2814565 Diagnostic to improve ENQUEUE block dump
9.2.0.4 2905433 Enhanced diagnostics for out of memory conditions during checkpoint
9.2.0.3 2235386 Improved diagnostics for ORA-60 deadlocks
9.2.0.3 2712701 Increased diagnostics for long enqueue timeouts in RAC
9.2.0.2 1788921 ENH: Add OCI_ATT_IS_EXTERNAL attribute to show table is EXTERNAL
9.2.0.2 2232905 Diagnostic to dump information for corrupt library cache handles in OPS/RAC
9.2.0.2 2294821 Additional diagnostics for OERI:12700
9.2.0.2 2352376 Enhancement: Improve heuristic for subquery unnesting for partially matches indexed correlation predicates
9.2.0.2 2387007 ENH: Allow UNUSED COLUMNS to be TRANSPORTED
9.2.0.2 2402677 ENH: Add JDBC thin OJMS support for all JMS message types on single destination
9.2.0.2 2402690 ENH: Add JDBC thin OJMS support for all JMS message types on single destination

2.1.11 Compressed Data Storage

The following table lists the Compressed Data Storage bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 4177800 Update on a compress table to set a column to NULL can corrupt the table
9.2.0.8 4378206 Direct load of compressed table can load duplicate rows
9.2.0.7 4085785 OERI[6191] on compressed partition direct export
9.2.0.6 3262424 ALTER TABLE NOCOMPRESS does not work for partitioned tables
9.2.0.6 3579567 Corrupt export exporting a compressed table with direct=y (IMP-9)
9.2.0.5 2680659 CTAS with COMPRESS fails with OERI[kd9alloc] with 32k block size
9.2.0.5 2999894 OERI:6032 / corrupt index creating a bitmap index on a compressed tables with bitmap indexes
9.2.0.5 3005508 ORA-28606 from CREATE COMPRESSED table / insert into compressed table
9.2.0.5 3230116 Direct export of a compressed table fails with OERI[6193]
9.2.0.3 2451259 ORA-28604 on recreate of BITMAP index on COMPRESSED table
9.2.0.3 2474106 COMPRESSION information not shown in dictionary views
9.2.0.3 2501800 ORA-7445 [kdblailb] from Direct path load into a COMPRESSed table
9.2.0.3 2553074 ORA-12996 should always occur ALTER TABLE DROP COLUMN after COMPRESS

2.1.12 Compressed Key Index / IOT

The following table lists the Compressed Key Index / IOT bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2977027 DBMS_METADATA generates incorrect DDL for local indexes
9.2.0.8 4178290 OERI[kghstack_underflow_internal_3]/OERI:711 on UPDATE with UNIQUE constraints
9.2.0.6 3347963 OERI [6120] during compressed IOT insert
9.2.0.6 3629771 Wrong results possible from COMPRESS KEY INDEX SCAN
9.2.0.5 2856059 * OERI[KCBGTCR_1] selecting from COMPRESSED IOT after UPGRADE from 8.1.7 to 9.2. This bug is alerted in Note:245918.1
9.2.0.5 2954868 OERI:kcoapl_blkchk / bad block from CR rollback of IOT or compressed index
9.2.0.5 3359471 Dump possible while doing DML against a table with compress key index
9.2.0.5 3423380 ONLINE MOVE of compressed IOT may dump or product corrupt IOT
9.2.0.4 2688197 ORA-1408 adding UNIQUE / PK CONSTRAINT with COMPRESSED KEY index
9.2.0.4 2718937 OERI:6033 from SELECT on IOT with COMPRESSED PRIMARY KEY
9.2.0.3 2566356 ONLINE MOVE of KEY-COMPRESSED IOT corrupts the IOT
9.2.0.3 2629193 OERI:[711]..[KDIFXS - PREFIX CONTEXT] selecting COMPRESSed key IOT
9.2.0.2 2215837 OERI:6100 / index corruption possible on compressed key index
9.2.0.2 2262336 Compute statistics on COMPRESSed key index has wrong DISTINCT KEYS value
9.2.0.2 2299683 PK not enforced if added using existing COMPRESSED NON UNIQUE index

2.1.13 Constraint Related

The following table lists the Constraint Related bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3765119 ALTER TABLE ADD <col> with foreign key constraint does not validate existing rows
9.2.0.8 3920138 ORA-2292 from advanced replication
9.2.0.8 4044738 OERI:qkaPIdsqkn1 adding referential constraint to partitioned table
9.2.0.8 4044798 Dump (kkdcgkc) from DML dereferencing scoped REFs
9.2.0.8 4178290 OERI[kghstack_underflow_internal_3]/OERI:711 on UPDATE with UNIQUE constraints
9.2.0.8 4198593 Apply incorrectly requires unconditional logging of Unique and FK constraints
9.2.0.8 4398475 Memory corruption from replicated table with self referencing FK constraints
9.2.0.8 4565536 OERI[insdrv-40] following PK violation in OCI_BATCH_ERRORS mode
9.2.0.8 4618715 Dump inserting into a view with OLS policy on tables
9.2.0.8 4620832 Dump in kzrtppg with multiple referential constraints and OLS policy
9.2.0.8 4742679 ORA-604 / ORA-28133 enabling constraints on table with FGA
9.2.0.7 2672986 SET CONSTRAINT DEFERRED sometimes errors out with ORA-1031
9.2.0.7 2972961 OERI[ktcdso-1] during refresh on commit of materialized view
9.2.0.7 3397761 DBMS_METADATA does not put a SQL terminator in CONSTRAINT definitions
9.2.0.7 3675530 Concurrent enable of CONSTRAINTS against same base table may dump
9.2.0.7 3731315 CREATE IOT with PK constraint may throw OERI [15803]
9.2.0.6 2858689 Wrong results possible from CHECK CONSTRAINTS which are not NULL SAFE
9.2.0.6 3097081 "ALTER TABLE x modify ..." cannot add certain column constraints (ORA-2253)
9.2.0.6 3275424 Array insert may report false constraint violations with row triggers
9.2.0.6 3352413 An ORA-8102 error can occur on ATEMPIND$ during a user UPDATE with CONSTRAINTS
9.2.0.6 3363424 Wrong results from query if base table as LPAD/RPAD/LTRIM/RTRIM check constraints
9.2.0.6 3418978 ORA-1 may be thrown immediately for a deferred constraint
9.2.0.6 3433964 Wrong result with deferred check constraint when table analyzed
9.2.0.6 3635177 Dump [KXCCUIN] possible from DML with concurrent ONLINE index rebuild
9.2.0.6 3676271 ORA-1403 applying DML with delete cascade constraints
9.2.0.5 2202404 ORA-2291 can occur using deferred constraints with partitioned indexes
9.2.0.5 2758287 Setup of multi-master replication can set up incorrect "DELETE_RULE" for constraints
9.2.0.5 2915902 Wrong results from not null-safe CHECK constraint
9.2.0.5 2936556 ORA-4030 on large multi table insert with Unique constraint
9.2.0.5 3010012 Dump modifying constraints which BITMAP JOIN INDEX relies on
9.2.0.5 3018017 ORA-28113 with referential constraints to table with VPD policy
9.2.0.5 3119025 Dump in KKOGTP possible from CBO when CHECK CONSTRAINTS exist
9.2.0.5 3150268 OERI[kcbgcur_1] / OERI:25012 deleting rows from PARENT table with LIST subpartitions
9.2.0.5 3171143 Wrong results from ANSI outer join with IS NULL predicate
9.2.0.5 3274939 ORA-1426 after ADD CONSTRAINT DISABLE VALIDATE / DROP CONSTRAINT
9.2.0.4 1874320 Constraints needlessly revalidated during import of transported tablespace metadata
9.2.0.4 2594803 EXCHANGE PARTITION with Unique constraints can be slow
9.2.0.4 2663465 Wrong results from CHECK CONSTRAINTS on OUTER JOINED table
9.2.0.4 2688197 ORA-1408 adding UNIQUE / PK CONSTRAINT with COMPRESSED KEY index
9.2.0.4 2688545 ORA-600 [QERNSROWP] from NOSORT with CHECK constraint/s
9.2.0.4 2750401 DEFERRABLE UNIQUE CONSTRAINTS can cause LOGICAL STANDBY apply errors
9.2.0.4 2754410 Multi-row insert SLOW with multiple FK constraints
9.2.0.4 2873855 "SET CONSTRAINTS ALL IMMEDIATE" may incorrectly signal violations
9.2.0.4 2878338 INSERT into HASH PARTITION may fail with false ORA-2291
9.2.0.4 2879257 OERI[16609] selecting from PARTITIONED table with CONSTRAINTS
9.2.0.3 2136347 ORA-4020 on CREATE OR REPLACE VIEW with SELF-REFERENTIAL CONSTRAINTS
9.2.0.3 2452631 Wrong results with CHECK CONSTRAINTS on OUTER JOIN columns
9.2.0.3 2470864 UPDATE may not update all rows if CHECK CONSTRAINT compares columns
9.2.0.2 2202561 Wrong results possible from CHECK CONSTRAINT with empty string ''
9.2.0.2 2236731 BULK ROW COUNT returned from ARRAY insert may be wrong if constraint violated
9.2.0.2 2258479 ORA-00600 [15264] enabling FOREIGN KEY constraint against a view
9.2.0.2 2281312 ORA-7445/dump possible on UPDATE of PRIMARY KEY enforced with a DESC index
9.2.0.2 2299683 PK not enforced if added using existing COMPRESSED NON UNIQUE index
9.2.0.2 2336714 PARALLEL MERGE does not error if the UPDATE violates a CHECK CONSTRAINT.
9.2.0.2 2435787 PDML may hang for tables with referential integrity constraints

2.1.14 Corrupt/Bad Backup

The following table lists the Corrupt/Bad Backup bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 5212539 + LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
9.2.0.8 4125093 OPEN RESETLOGS is not possible if RMAN backup omits plugged-in READ ONLY tablespaces
9.2.0.8 5032964 ORA-19731 whilst recovering plugged in file
9.2.0.7 4074603 + RMAN backup of primary with a standby using FAL may omit archivelogs
9.2.0.7 3575797 XMLSchemas and types are not exported in table and tablespace mode export
9.2.0.7 3685659 Export of DOMAIN INDEXes can write truncated CREATE INDEX information to the DMP file
9.2.0.7 3738705 Incorrect CREATE TABLE SQL written to DMP file for "not substitutable at all levels"
9.2.0.7 3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
9.2.0.7 3844804 RMAN DELETE .. BACKED UP n TIMES can delete an archivelog not yet backed up
9.2.0.7 3861505 RMAN does not resync archivelogs produced before switchover
9.2.0.7 4015652 Nested Table export fails with ORA-1007
9.2.0.7 4047608 Export/import can loose the LOGGING attribute of LOB columns
9.2.0.7 4154125 Export writes bad SQL to DMP file for XMLTYPE tables with DEFAULT clauses
9.2.0.6 2825248 Resetlogs data ignored in RMAN backup optimization checks
9.2.0.6 3297877 OERI[2036] due to bad redo from direct writes
9.2.0.6 3615004 Corrupt backup / ORA-19675 using RMAN PROXY backup in RAC environment
9.2.0.5 2517589 Some types of redo corruption are not detected when they should be
9.2.0.5 2599134 Archivelog records in the CONTROLFILE may have wrong length data
9.2.0.5 2665255 RMAN-6004 ORA-1455 if clock adjusted back during RMAN backup
9.2.0.5 2808926 OERI[2866] possible during MEDIA recovery of AUTOEXTEND file in RAC
9.2.0.5 3204542 OERI[ktssinseg3] / cannot recover locally managed tablespace
9.2.0.3 2645378 + LOB data corruption after RECOVERY
9.2.0.2 2334532 Not all backuppieces have a magic buffer written

2.1.15 Corruption

The following table lists the Corruption bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2718475 DML on table with supplemental log group does the wrong thing or OERIs
9.2.0.8 3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
9.2.0.8 4046842 Table level export/import can produce corrupt TYPE metadata
9.2.0.8 4053888 ORA-1499 diagnostic trace does not dump REDO for the table block
9.2.0.8 4198000 ORA-22993 / unreadable LOB data with temp CLOB
9.2.0.8 4310371 OERI [25027] from concurrent startup / shutdown in RAC
9.2.0.8 4594912 Incorrect checkpoint possible in datafile headers
9.2.0.8 4655520 Block corrupted during write not noticed
9.2.0.8 4767487 Hex dump of corrupt block not written to trace
9.2.0.8 5017007 MVIEW LOB content incorrect after refresh
9.2.0.7 3022968 Serializable transaction is not properly isolated
9.2.0.7 3879787 OERI [kcoapl_blkchk] during multi-block undo for CR
9.2.0.7 3966709 Range/object reuse prematurely (ORA-8103)
9.2.0.7 4121673 DBMS_SPACE_ADMIN.assm_segment_verify does not detect certain corruptions
9.2.0.7 4131045 Add DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY
9.2.0.6 2696988 CR index block corruption from undo of array delete
9.2.0.6 2729654 Downgrade from 10g with recreate controlfile can cause future upgrade problem
9.2.0.6 3262494 Block corruption possible during CR rollback of an insert rowpiece
9.2.0.6 3489246 OERI[pitl1] / ORA-1498 ANALYZING table transported from 8.1.7 to 9.2.0

2.1.16 Corruption (Corrupt Export)

The following table lists the Corruption (Corrupt Export) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3983923 Export of a partition with a nested table column exports all nested table rows
9.2.0.8 4186247 Bad export / IMP-8/IMP-9 when importing long user defined types
9.2.0.7 4154125 Export writes bad SQL to DMP file for XMLTYPE tables with DEFAULT clauses
9.2.0.6 3579567 Corrupt export exporting a compressed table with direct=y (IMP-9)
9.2.0.5 2666174 Export in direct path can product a corrupt export file if ORA-1555 occurs
9.2.0.5 2902986 Clustered table direct export produces a corrupted dump exporting migrated rows
9.2.0.5 3031024 Export of object types and many subtypes produces bad export file (OCI-22303 on import)
9.2.0.5 3041342 Bad DDL in export file exporting a table which is not substitutable at all levels
9.2.0.5 3071475 Export writes bad DDL for user defined types stored as LOBs
9.2.0.5 3085706 Transporting a partitioned table with SUBPARTITION TEMPLATE fails with ORA-2220
9.2.0.5 3091499 Bad export / import dumps for table with LOB CHUNKSIZE = 32K
9.2.0.5 3150037 Export may produce wrong SQL for CREATE TABLE xxx OF typename
9.2.0.4 2746788 + Export does not error on DISK FULL conditions (IMP-9 on import)
9.2.0.4 2862818 Bad export of NESTED table in LOCALLY managed tablespace - ORA-25150 / ORA-942 on import
9.2.0.3 2598387 * Export / OCI clients using prefetch may see corrupt data. This bug is alerted in Note:223399.1

2.1.17 Corruption (Dictionary)

The following table lists the Corruption (Dictionary) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 4192148 + Incorrect view definition in DBA_VIEWS for "SELECT x.*" type views
9.2.0.8 2212987 Dictionary corruption can occur as function index allowed when it should not
9.2.0.8 3936576 Dictionary corruption modifying ADT column to NOT SUBSTITUTABLE
9.2.0.8 4203874 Dictionary corruption after DROP partition (can cause OERI:17059)
9.2.0.8 4748597 Moving a LOB in a partitioned table fails to update IND$
9.2.0.7 2597763 SPLIT of a COMPOSITE PARTITION can corrupt the dictionary (duplicate DATAOBJ#)
9.2.0.7 3172957 OERI[ktadrprc-1] / ORA-955 during DDL
9.2.0.7 4142932 DBA_SEGMENTS.EXTENTS wrong for locally managed segment after TRUNCATE operation
9.2.0.6 2617487 Dropping unused columns can corrupt the dictionary for the table
9.2.0.6 2921194 ALTER TABLE allows wrong partition to be added into the existing table
9.2.0.6 2950468 ALTER SNAPSHOT makes a readonly snapshot updatable
9.2.0.6 3370917 Summary metadata corrupted during REFRESH if MVIEW has inline views
9.2.0.6 3410546 Function-based index metadata left in COL$ after column is dropped
9.2.0.6 3455402 Concurrent DROP / ALTER TABLESPACE READ ONLY can corrupt the dictionary
9.2.0.6 3608307 OERI[7001] / dictionary corruption from upgrade/downgrade with materialized views
9.2.0.5 2314382 NUMBER precision missing for VIEW of a table expression
9.2.0.5 2553841 ALTER TABLE synonym_name ADD PARTITION works when it should fail
9.2.0.5 2570545 Queries after a 'DROP SUBTYPE VALIDATE' can fail with ORA-21700
9.2.0.5 2717778 Update of a view throws ORA-1732 if the view was recreated and had a INSTEAD OF trigger on it
9.2.0.5 2785745 Drop user cascade can leave capture/apply metadata in an inconsistent state
9.2.0.5 2803911 Target sees corrupt data in TRANSPORTED tablespace with UNUSED columns
9.2.0.5 2856745 Duplicate rows in database_properties table after migration from 8i to 9i
9.2.0.5 2964982 Running prvtlock.plb during upgrade can leave duplicate lock handles
9.2.0.5 3046194 Drop/recreate of an OPERATOR does not update dictionary properly - affects Text SCORE operator
9.2.0.5 3091612 TAB$.SPARE6 may contain corrupt data after upgrade to 9i
9.2.0.5 3149359 Dictionary corruption from failed ALTER TABLE ADD CONSTRAINT with ONLINE clause
9.2.0.5 3226011 VARRAY storage table not dropped when parent column dropped
9.2.0.5 3274939 ORA-1426 after ADD CONSTRAINT DISABLE VALIDATE / DROP CONSTRAINT
9.2.0.4 2702410 ORA-8104 / ORA-8106 occur on ALTER MOVE / REBUILD ONLINE
9.2.0.4 2781500 Dictionary corruption possible if DBMS_RULE_ADM.DROP_RULE / DROP_EVALUATION_CONTEXT errors
9.2.0.4 2809130 Queue import can corrupt dictionary metadata if queue pre-exists
9.2.0.4 2897947 Dictionary (COL$.PROPERTY) does not contain INSERTABLE FLAG when CTAS uses UPPER function
9.2.0.4 2909084 RENAME of a VIEW with CHAR column can cause wrong results for subsequent SQL
9.2.0.4 2976763 Failed DROP MVIEW can leave corrupt dictionary data - subsequent ORA-30382
9.2.0.3 2591284 * Upgrade to 9i may fail leaving bad KOTTD$ type information in dictionary. This bug is alerted in Note:215522.1
9.2.0.3 2381172 + IMPORT fails / corrupts the AQ dictionary with duplicate QUEUE_TABLE names
9.2.0.3 1584155 DROP FORCE/RECREATE TYPE with DEPENDENCIES corrupts dictionary information
9.2.0.2 2371453 + CREATE OR REPLACE SYNONYM can lead to inconsistent dictionary (old IDL data)
9.2.0.2 2161360 DROP of OPERATOR corrupts dictionary - ORA-29836 on ALTER INDEXTYPE
9.2.0.2 2286290 ALTER TABLE MOVE should not be allowed for Queue tables
9.2.0.2 2377630 OERI[5106] / dictionary corruption on concurrent ADD DATAFILE & DROP TABLESPACE
9.2.0.2 2380475 Dictionary corruption from CREATE OR REPLACE SYNONYM on TYPE
9.2.0.2 2405258 Dictionary corruption / OERI:15265 from MOVE LOB to existing segment name
9.2.0.2 2498186 DEPENDENCY$ corrupted on ALTER INDEXTYPE
9.2.0.2 2515703 Dictionary corruption from concurrent partitioned IOT maintenance

2.1.18 Corruption (Incorrect / Missing Corruption Checks)

The following table lists the Corruption (Incorrect / Missing Corruption Checks) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 4720333 Block corruptions reported media recovery
9.2.0.7 3823550 False ORA-1499 validating a table CASCADE ONLINE with a bitmap index
9.2.0.7 3868753 Concurrent export / INSERT of ASSM segment can fail with ORA-1410 / ORA-8103
9.2.0.6 3569503 PQ may signal a false ORA-8103 under load
9.2.0.6 3622875 False ORA-1499 from ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE
9.2.0.5 2517589 Some types of redo corruption are not detected when they should be
9.2.0.4 2551000 False ORA-1410 / ORA-8103 possible from ANALYZE COMPUTE/ESTIMATE STATISTICS
9.2.0.4 2870048 False corrupt block messages in alert log
9.2.0.3 2348277 DBV/RMAN may incorrectly report completely zero blocks as corrupt
9.2.0.3 2354965 False fractured block messages possible during Direct Path IO
9.2.0.3 2469314 DBVERIFY may dump when reporting a block corruption
9.2.0.2 2373145 DBVERIFY does not identify fractured blocks
9.2.0.2 2432864 DBVERIFY does not work properly on RAW or for different BLOCKSIZE

2.1.19 Corruption (Index)

The following table lists the Corruption (Index) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2955004 OERI[kauxs_do_jou:3] / corrupt index from online index rebuild with concurrent DML
9.2.0.8 3780505 OERI[6302]/corrupt index creating functional index from existing local index
9.2.0.8 4246090 IOT corruption from buffered INSERT with function based index (ORA-8102)
9.2.0.8 4409977 Insert into a partition with bitmap indexes can corrupt the index (ORA-1499)
9.2.0.7 4030374 Parallel DML into partitioned table may produce index corruption
9.2.0.6 2942185 Corruption occurs on direct path load into IOT with ADDED columns
9.2.0.5 2093670 OERI:12700 / BITMAP index corruption possible
9.2.0.5 2758680 Parallel index create / rebuild may produce a corrupt index (rare)
9.2.0.5 2999894 OERI:6032 / corrupt index creating a bitmap index on a compressed tables with bitmap indexes
9.2.0.5 3030585 Corrupt TEXT index possible for LONG columns
9.2.0.5 3097158 OERI[6006] / index corruption possible (rare)
9.2.0.5 3115733 OERI[4000] / index corruption can occur during index coalesce
9.2.0.5 3145991 Bitmap index corruption possible (rare)
9.2.0.4 2909160 OERI[6122] / index corruption for DML against AUTO space managed indexes
9.2.0.3 2729655 Direct load of PARTITION may not update bitmap index
9.2.0.2 2215837 OERI:6100 / index corruption possible on compressed key index
9.2.0.2 2299909 ARRAY UPDATE can cause TABLE / INDEX inconsistency

2.1.20 Corruption (Logical)

The following table lists the Corruption (Logical) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3494853 Unrelated triggers may be incorrectly dropped when dropping tables/views
9.2.0.8 3765119 ALTER TABLE ADD <col> with foreign key constraint does not validate existing rows
9.2.0.8 3983762 Audit followed by noaudit corrupts failure value in audit$
9.2.0.8 4246090 IOT corruption from buffered INSERT with function based index (ORA-8102)
9.2.0.8 4378206 Direct load of compressed table can load duplicate rows
9.2.0.8 4397882 Binding a collection of objects with certain data via PLSQL binds null
9.2.0.8 4496211 Wrong results after fast refresh of a partitioned materialized view
9.2.0.8 4515623 Update .. RETURNING with a trigger can produce corrupt column data
9.2.0.8 4630627 Direct load insert loads incorrect data
9.2.0.8 4711857 Exp/Imp of table with LONG swaps COMMENTS metadata
9.2.0.8 4714295 It is possible to drop an OLS group which is still in use in an existing label
9.2.0.8 4771052 INSTEAD-OF trigger does not update tables correctly over dblink
9.2.0.8 4775068 Deferred transactions not applied in the correct order when using parallel propagation
9.2.0.8 4995049 Invalid data inserted into schema based document
9.2.0.7 2670601 MERGE does not work correctly for HASH clusters (wrong result)
9.2.0.7 3419707 Varying width CLOB data padded with blanks over database link
9.2.0.7 3534299 SQLLDR may load corrupt NUMBER data for invalid ZONED DECIMAL data
9.2.0.7 3682068 MV log changes not recorded with complex statement
9.2.0.7 3720988 Wrong values after OCCI setNull of number varray / vector values
9.2.0.7 3743437 Corrupt packed decimal data loaded by SQLLDR conventional path
9.2.0.7 3743445 Direct path SQLLDR may load incorrect numbers for PACKED DECIMAL data
9.2.0.7 3798351 Importing a pre-existing table may DROP the table on an error
9.2.0.7 3823608 Conventional path load may load incorrect scale/precision for numbers
9.2.0.7 3824149 Missing data possible from Insert as SELECT over database link
9.2.0.7 3880405 DBMS_XMLDOM.setnodevalue does not change the nodes value
9.2.0.7 3908083 SQLPLUS COPY truncates long data with gateway connections
9.2.0.7 3913642 OERI[knlqdqm2usr:4] / incorrect data at Logical Standby
9.2.0.7 3957590 Corruption from failed distributed transaction in RAC environment
9.2.0.7 3960844 Switch to logical standby may not see active PLSQL changes (data missing)
9.2.0.7 4019844 AQ notifications triggered for rolled back messages on single consumer queues
9.2.0.7 4156695 Values of XML 'long' element are stored incorrectly in schema based table
9.2.0.7 4157832 SQLLDR direct path SQL expressions can load NULLs into NOT NULL columns
9.2.0.6 2660473 Export of a renamed table leaves the trigger pointing to the old tablename
9.2.0.6 2719742 Too many rows inserted by MERGE if a row is updated before the merge operation
9.2.0.6 2879641 BEFORE ROW TRIGGER produces corrupt data with INSERT from SORT MERGE JOIN
9.2.0.6 2928563 Using large collections with EXTPROC can return 0 size collection
9.2.0.6 3111464 Fast refresh gives wrong data after update of filter column from null to value
9.2.0.6 3127987 NCLOB data is corrupted after insert through JDBC
9.2.0.6 3128021 Corrupt column data after EXCHANGE PARTITION with row dependencies
9.2.0.6 3265740 Corrupt column data after PARTITION maintenence with ROWDEPENDENCIES
9.2.0.6 3313274 Direct path load of LOBs can cause data loss/truncation in streams
9.2.0.6 3361118 OERI:[7999] / LOB corruption updating a LOB in a SERIALIZABLE transaction
9.2.0.6 3365045 Functional index on DATE column can depend on NLS_DATE_FORMAT (ORA-8102 on DML)
9.2.0.6 3370235 Corrupt data possible in logical standby
9.2.0.6 3393350 NLS characters may be corrupted over DB link for NCHAR data with OCI7
9.2.0.6 3571946 DELETE trigger does not fire on delete with index scan
9.2.0.6 3686945 Long CLOB data not updated correctly with LOB buffering in multibyte DB
9.2.0.6 3687456 OERI[ktspgetmyb-1] / Corrupt LOB if EXTENT size not multiple of LOB CHUNK SIZE
9.2.0.6 3700058 Rollback to a savepoint with a DB link can result in a full rollback
9.2.0.6 3740473 Wrong row deleted when using ROWNUM over a view with an ORDER BY
9.2.0.5 3288804 * Trigger updates wrong column after drop function-based index. This bug is alerted in Note:259854.1
9.2.0.5 2276863 + CREATE FORCE VIEW against missing remote object may not work properly
9.2.0.5 979657 Oracle allows insert of -0 (negative zero) or other corrupt numbers from OCI/Pro
9.2.0.5 2341550 CURRENT_SCHEMA not set with database ON_LOGON trigger using SQLLDR with DIRECT=TRUE
9.2.0.5 2623901 Multi TABLE INSERT (INSERT ALL) with ROW TRIGGERS fires wrong triggers or throws OERI:15852
9.2.0.5 2790435 Serial INSERT with parallel SELECT and type conversion can insert corrupt data
9.2.0.5 2842621 LOB DML failure can lead to corrupt LOB data at APPLY site
9.2.0.5 2846610 SQLPLUS COPY with COPYCOMMIT may fail / copy null rows to HS gateway
9.2.0.5 2853704 oracle.sql.DATE addJulianDays can produce corrupt date values
9.2.0.5 2861835 Streams apply may contain direct loaded LOB data which was rolled back
9.2.0.5 2870079 Create Bitmap index skipped at logical STANDBY site
9.2.0.5 2892729 PDML direct path insert not replicated to the logical standby
9.2.0.5 2963428 Incorrect dates possible using TIMESTAMP WITH LOCAL TIMEZONE
9.2.0.5 2986350 MERGE may not be applied properly at APPLY site
9.2.0.5 3035145 OCCI does not evaluate null/not null correctly after number::setnull()
9.2.0.5 3041411 Before/After row triggers fire incorrectly for MERGE statements
9.2.0.5 3058476 SEQUENCES not properly maintained at Logical Standby
9.2.0.5 3077339 OCCI: iterated setNumber() causes ORA-1438 or wrong results / corrupt data
9.2.0.5 3088916 SQLLDR direct path does not evaluate SQL strings for NULL input data
9.2.0.5 3111598 CHAR columns not BLANK PADDED after CREATE MVIEW / refresh with different charsets
9.2.0.5 3118922 Binding over HS as a Packed decimal type can produce wrong data
9.2.0.5 3128209 UPDATEXML may not work when used in a trigger
9.2.0.5 3128775 Empty / corrupt XML data can be inserted via XMLType
9.2.0.5 3159030 Multi table insert may not recognise column alias
9.2.0.5 3170016 HS data corruption if > 32K RAW data is passed to a procedural gateway
9.2.0.5 3174298 SQLLDR direct path load may load 0 instead of NULL if length-value is NULL
9.2.0.5 3188573 Streams LOB corruption at apply site possible
9.2.0.5 3207216 Valid ISO characters can get corrupted with OJMS using OCI driver
9.2.0.5 3230177 AQ JMS can truncate the payload
9.2.0.5 3239914 Fast refresh data is not reflected in materialized view
9.2.0.4 2797392 + Streams / logical standby does not replicate DDL from PLSQL "EXECUTE IMMEDIATE"
9.2.0.4 2886004 + Reverse default behaviour for blank trimming of Control characters
9.2.0.4 2511699 Silent data truncation inserting char literal into NVARCHAR2 column
9.2.0.4 2594726 JDBC Array insert > 65535 elements may product NULL rows / fail with ORA-6531
9.2.0.4 2679297 Non numeric characters can be inserted into a NUMBER column in HS
9.2.0.4 2708284 Loader misreads secondary datafiles for VARRAYs / Nested Tables
9.2.0.4 2767857 SQLLOAD of NULL LOB loads previous LOB value
9.2.0.3 2645455 + Control characters are trimmed from bind variables
9.2.0.3 2697938 + UPDATE of object table sets columns to NULL with index only access
9.2.0.3 2234028 CREATE TABLE OF <TYPE> AS SELECT can produce invalid table data
9.2.0.3 2470864 UPDATE may not update all rows if CHECK CONSTRAINT compares columns
9.2.0.3 2473741 Before row update trigger may not fire for MERGE statement
9.2.0.3 2508682 Under heavy load concurrent sessions may use wrong shared cursor (wrong schema)
9.2.0.3 2541038 Streams / Logical standby get corrupt/missing data for row migrated partitioned LOB columns
9.2.0.3 2563206 CLOB data is corrupted when inserted from an 8.0 client to multibyte 9.2 server
9.2.0.3 2656881 LOB data corrupt after migrating DB from single -> multibyte
9.2.0.3 2685269 ASSM segment may become corrupt - OERI[ktspstchg-1] on DELETE from table/index
9.2.0.3 2732343 Streams capture update of LOB data > 32K gives wrong length on APPLY
9.2.0.2 1733957 Array interface deletes too many rows with correlated subquery
9.2.0.2 2014766 Java TRIGGERS do not set :NEW variables to the new values
9.2.0.2 2025426 Bad number data / NumberFormatException with leading 0's in number string in JDBC
9.2.0.2 2197703 Update of LONG with PLSQL BULK BIND can update incorrectly
9.2.0.2 2232548 VARRAY number columns are not rounded / truncated
9.2.0.2 2245006 OCCI populating NESTED TABLE / VARRAY > 245 elements inserts corrupt data
9.2.0.2 2259466 PLSQL: Assigning one VARRAY to another produces corrupt VARRAY - ORA-6533 / OERI:KOPE2_READSTR232
9.2.0.2 2299683 PK not enforced if added using existing COMPRESSED NON UNIQUE index
9.2.0.2 2314238 VARCHAR2 Bind variables loose any TRAILING SPACES when used over a DATABASE LINK or bound dynamically
9.2.0.2 2336714 PARALLEL MERGE does not error if the UPDATE violates a CHECK CONSTRAINT.
9.2.0.2 2367256 Fix for Bug:2133357 not in Oracle9i (Corrupt LOBS after altering DB characterset)
9.2.0.2 2386401 LOADER may load incorrect values for PACKED DECIMAL data
9.2.0.2 2421031 VARRAY of FLOATs are truncated on insert
9.2.0.2 2423571 Invalid Oracle numbers possible if ProCobol uses COMP variables containing invalid COMP data
9.2.0.2 2448081 DIRECT load loads PACKED DECIMALS exceeding specified precision / scale
9.2.0.2 2468782 Direct load with SQL expression in CONTROL file can fail / store incorrect data

2.1.21 Corruption (Physical)

The following table lists the Corruption (Physical) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 5212539 + LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
9.2.0.8 4177800 Update on a compress table to set a column to NULL can corrupt the table
9.2.0.8 4260477 OERI[kcoapl_blkchk] / block corruption with 32k blocksize
9.2.0.8 4411228 Block corruption with mixture of file system and RAW files
9.2.0.8 4517470 Table corruption with RAC when ASSM managed and truncate used
9.2.0.7 3440689 Block corruption possible inserting large row piece to empty block
9.2.0.7 3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
9.2.0.7 3779310 OERI[kcoapl_blkchk] / block corruption on update of IOT
9.2.0.7 3785333 DROP COLUMN may drop wrong columns in an IOT with OVERFLOW
9.2.0.7 3811391 Updates to IOTs beyond column 255 in non-key piece can corrupt the IOT
9.2.0.7 3859298 Block corruption with high INITRANS or rapid ITL growth.
9.2.0.7 4000840 Update can cause block corruption
9.2.0.6 3785200 * Corruption possible in automatic space managed segments. This bug is alerted in Note:281047.1
9.2.0.6 2576703 IOT block corruption from insert after columns added to all-key IOT
9.2.0.6 3069818 Corruption possible modifying a migrated or chained row
9.2.0.6 3641822 PDML (including DDL) can cause APPLY to stop
9.2.0.6 3641963 Transport of a table with LONG RAW and added columns is corrupt at target
9.2.0.5 2599134 Archivelog records in the CONTROLFILE may have wrong length data
9.2.0.5 2881183 Dump (kdisplitbr) / random data/index corruption (rare)
9.2.0.5 2927357 OERI[kcoapl_blkchk]/corruption possible from block level rollback
9.2.0.5 2950062 ORA-4030 during block recovery can cause block corruption
9.2.0.5 3029292 LOB corruption possible on ASSM tablespace
9.2.0.5 3085651 Table corruption / OERI after TRUNCATE on ASSM table with NESTED TABLE cols
9.2.0.5 3111951 OERI[ktspscaninit-d] after interrupted TRUNCATE
9.2.0.5 3210520 OERI[kjccqmg:esm] / OERI[4194] / corruption possible in RAC
9.2.0.5 3213101 Lob corruption / ORA-1555 can occur on a LOB segment in ASSM
9.2.0.5 3215579 OERI[ktspfupdst-1] / corruption after DEALLOCATE UNUSED on ASSM
9.2.0.5 3249755 Block corruption possible on temp files
9.2.0.5 3281882 Block corruption / OERI[kcoapl_blkchk] in multinode RAC after multiple reconfigurations
9.2.0.5 3377351 Corruption possible in RAC if instances crash during recovery
9.2.0.5 3397181 ALTER SYSTEM KILL SESSION of recovery slave causes stuck recovery
9.2.0.5 3423380 ONLINE MOVE of compressed IOT may dump or product corrupt IOT
9.2.0.4 2914002 P* VMS: Corruption / crash using RAC on VMS with TCPIP interconnect. This bug is alerted in Note:244940.1
9.2.0.4 2431450 SMU Undo corruption possible on instance crash
9.2.0.4 2537604 RAC graceful failover may result in corrupt new primary database
9.2.0.4 2742254 In RAC a transaction can use an offline rollback segment causing corruption
9.2.0.4 2798239 Block corruption possible on rollback of segment merge
9.2.0.4 2967417 OERI:KCOAPL_BLKCHK may occur using Auto managed segment
9.2.0.3 2157903 + MOVE of MVIEW corrupts the data or dumps (ORA-7445 [qerltRop] or similar)
9.2.0.3 2645378 + LOB data corruption after RECOVERY
9.2.0.3 2620053 P+ AIX5L: Corrupt blocks (ORA-1578) possible using AIX Logical Volumes
9.2.0.3 2541360 V$BACKUP_SPFILE records can get corrupted / RMAN-10031
9.2.0.3 2542609 Corruption from CANCEL of managed standby if primary is RAC
9.2.0.3 2562274 Block corruption / OERI[KCOAPL_BLKCHK] updating LONG data
9.2.0.3 2566356 ONLINE MOVE of KEY-COMPRESSED IOT corrupts the IOT
9.2.0.3 2585648 OERI:[KCCCHB_1] should CRASH the instance but does not
9.2.0.2 2384289 * Corruption / internal errors after upgrading database to 9.2. This bug is alerted in Note:197737.1
9.2.0.2 2293492 Fatal error during COMMIT / ROLLBACK may cause permanent corruption (eg: ORA-8102)
9.2.0.2 2366191 Database corruption possible from concurrent ALTER DATABASE OPEN
9.2.0.2 2399039 ALTER TABLE DROP COLUMN drops the wrong column
9.2.0.2 2485931 ORA-8102 from IOT DML with concurrent MOVE ONLINE

2.1.22 DBVerify Utility

The following table lists the DBVerify Utility bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3981329 DBV-102 accessing file being written in O_DIRECT mode by DBWR
9.2.0.7 3571244 dbverify does not report "marked corrupt" blocks in its summary
9.2.0.6 3457571 Enhancement to DBV to show highest SCN in a file / show blocks above an SCN
9.2.0.3 2348277 DBV/RMAN may incorrectly report completely zero blocks as corrupt
9.2.0.3 2469314 DBVERIFY may dump when reporting a block corruption
9.2.0.2 2326948 DBV-111 using DBVERIFY SEGMENT_ID=... on a bitmap space managed segment
9.2.0.2 2373145 DBVERIFY does not identify fractured blocks
9.2.0.2 2432864 DBVERIFY does not work properly on RAW or for different BLOCKSIZE

2.1.23 Database Link / Distributed

The following table lists the Database Link / Distributed bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2283149 Hint on remote table may be lost
9.2.0.8 2902721 Dump [qkaPobs] from INSTEAD OF trigger on a view on a remote table
9.2.0.8 3060358 Open cursors using a sequence in a remote database are not closed (ORA-1000)
9.2.0.8 3413826 ORA-904 from MERGE SQL across database link
9.2.0.8 3547585 Using CONNECT BY over a database link to 8i can fail with ORA-1472
9.2.0.8 3828598 Wrong results with unnested remote subqueries
9.2.0.8 3901321 Dump during DDL on remote table with domain index
9.2.0.8 4127518 ORA-928 / ORA-2063 or dump (qkswcInlineQBC) when SET expression over a database link
9.2.0.8 4146079 Dump in xplInitCtx from remote mapped table in query
9.2.0.8 4177810 ORA-904 with non-column constants in FROM clause with PQ or remote SQL
9.2.0.8 4257473 ORA-920 can occur for SQL over a database link
9.2.0.8 4307318 No anti-join optimization for INSERT as SELECT with NOT IN subquery over db link
9.2.0.8 4308123 OERI[18117] on PREPARE if branch has updated remote site
9.2.0.8 4321119 ALTER MATERIALIZED VIEW causes ORA-32337 after DML via database link
9.2.0.8 4344210 Dump (kpobav) if remote mapped cursor rebuilt
9.2.0.8 4357668 Dump (k2ggse1) can occur during prepare of multi-branch transaction
9.2.0.8 4402255 Hang / dump possible using database link
9.2.0.8 4431181 Dump from SELECT if it changes from remote mapped to not
9.2.0.8 4451759 OERI:729 using session cached cursors with DB link
9.2.0.8 4490782 Unparse operations give wrong date for BC TO_DATE literals
9.2.0.8 4543879 OERI[OCIKDBLinkConn-8], [24327] from parallel distributed update
9.2.0.8 4581334 Cursors accessing remote tables may be repeatedly rebuilt and not used
9.2.0.8 4618265 DBMS_PLAN.display / plan_table shows wrong plan for remote queries with BINDs
9.2.0.8 4622095 Dump kkdlacd() when creating stored outline for DML against a remote table
9.2.0.8 4627237 autonomous_transaction with DB link to shared server can self deadlock on DX
9.2.0.8 4658456 ORA-920 from distributed query using CASE against remote table/s
9.2.0.8 4701527 Cursors not shared when executing procedures over a dblink
9.2.0.8 4703253 Wrong results from remote colocated join
9.2.0.8 4708037 ORA-904, ORA-2063 from query that uses TIME ZONE as a cast
9.2.0.8 4768022 ALTER TABLE can fail with ORA-60
9.2.0.8 4771052 INSTEAD-OF trigger does not update tables correctly over dblink
9.2.0.8 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
9.2.0.8 4968994 Poor plan using SYSDATE in predicate over dblink
9.2.0.8 5043975 OERI[opixrm-1] [invalid handle] for remote cursor
9.2.0.7 2307997 OERI [kolaHashFind:hash table] from SELECT xmltypeview over a database link
9.2.0.7 2887209 UGA memory leak / OERI:729 with failed shared database link connection
9.2.0.7 3081127 View for remote table with CHECK OPTION never reports ORA-1402
9.2.0.7 3133359 OERI[nconumcrsr-1] selecting from V$DBLINK
9.2.0.7 3419707 Varying width CLOB data padded with blanks over database link
9.2.0.7 3469121 OERI from MERGE statement with database link and sequence
9.2.0.7 3486283 Dump (rwocmf) from SQL involving subqueries accessing remote databases
9.2.0.7 3624684 Remote subquery not unnested when expected
9.2.0.7 3637267 Varchar2 is blank padded when local DB charset is different from remote site
9.2.0.7 3647829 Cursor is not always closed when database link closed (ORA-1000)
9.2.0.7 3672565 ORA-1461 when binding data larger than 4k through a database link
9.2.0.7 3776668 ORA-1478 from distributed transaction between 8i<->9i with different character sets
9.2.0.7 3795386 Insert as select of LOBS / XMLType across DB Link can leak memory
9.2.0.7 3804250 DML to a remote table from a table with FGA fails with ORA-904/ORA-2063
9.2.0.7 3808670 Private memory leak from INSERT INTO over Database link
9.2.0.7 3824149 Missing data possible from Insert as SELECT over database link
9.2.0.7 3854478 ORA-935 executing SQL with analytic functions over a database link
9.2.0.7 3858625 Insert of long over DB link with NULL binds may ORA-24343
9.2.0.7 3875506 ORA-2019 executing PLSQL block over a private database link
9.2.0.7 3924711 Wrong results for CHAR-CHAR join with transitive predicates over database link
9.2.0.7 3929805 Slow execution for insert as Select over DB Link with NULL in select list
9.2.0.7 3933012 ORA-904 from IN subquery with UNION ALL having co-located remote references
9.2.0.7 3949188 Dump (kopxccc) when calling a procedure over database link
9.2.0.7 3954056 Dump possible accessing remote site in NESTED LOOPS query
9.2.0.7 3957590 Corruption from failed distributed transaction in RAC environment
9.2.0.7 3982017 ORA-3106 PLSQL SELECT across 8i-9i-8i
9.2.0.7 4030117 Revised fix for bug 3076160
9.2.0.7 4154611 ORA-22992 can occur for distributed XML queries
9.2.0.7 4165093 Dump (in kkocpr) for SQL over database link
9.2.0.7 4172303 In-doubt transaction may be left PREPARED at a remote site
9.2.0.6 2256943 Dump (in kohalw) selecting TEMPORARY LOB over a DBLINK
9.2.0.6 2597829 Poor execution plan possible for remote inserts
9.2.0.6 2610353 Dump / memory corruption possible from remote select
9.2.0.6 2624328 Query over database link can return wrong results
9.2.0.6 2840895 ORA-22921 inserting into remote CLOB with varying width characterset
9.2.0.6 2851970 Dump possible for SQL over DB LINK if temp table transformation occurs
9.2.0.6 2876340 ORA-904 accessing a remote object from PLSQL (remote DB < 9i)
9.2.0.6 2932269 Sessions hang on "resmgr:waiting in end wait" while session tries to connect over DBLINK
9.2.0.6 3031118 Wrong result joining a local table with a remote table
9.2.0.6 3061457 ORA-2019 from Jdbc Thin
9.2.0.6 3069714 Dump possible in ddfnetCFull from remote query
9.2.0.6 3110547 ORA-904 / wrong results from query over database link
9.2.0.6 3148830 Select over database link fails with OERI[opixmp-7] if CURSOR_SHARING=similar
9.2.0.6 3219124 DCD stops working if a DB LINK name is resolved via LDAP name resolution
9.2.0.6 3263671 ORA-2019 from INSERT INTO .. SELECT from remote LOB using a PUBLIC synonym
9.2.0.6 3273109 Wrong results possible for NULL in SELECT list for PQO or remote query
9.2.0.6 3278020 ORA-942 creating MVIEW across dblink from 9i to 8i for object table
9.2.0.6 3367979 Distributed query on partition table fails with ORA-2021
9.2.0.6 3393350 NLS characters may be corrupted over DB link for NCHAR data with OCI7
9.2.0.6 3393962 ORA-972 on query with UNION ALL and internally generated column name over DBLINK
9.2.0.6 3411748 OCI7 SELECT FOR UPDATE over DBLINK may dump client in kpuridalo1
9.2.0.6 3430426 ORA-1459 attempting to SELECT a LONG via a database link with multibyte using JDBC
9.2.0.6 3447478 ORA-6502 calling PLSQL over a DBLINK with RECORD parameters with UTF8/AL32UTF8
9.2.0.6 3456977 ORA-2046 using SQL with AUTOCOMMIT for DB link between 9i/10g and 8i
9.2.0.6 3458438 Update a long >4k that affects more than 1 record over DB link hangs
9.2.0.6 3465087 ORA-905 possible from CAST() over DB link if "AT" clause is a column name
9.2.0.6 3498315 Insert CLOB datatype from single-byte database to UTF8 hangs
9.2.0.6 3512385 Wrong ROWID returned from SELECT over DBLINK when PREFETCH is on
9.2.0.6 3532017 OERI:kokegPinLob1 possible inserting CLOB from 10g to 9.2
9.2.0.6 3545209 Poor performance from semi join with NL to remote table
9.2.0.6 3571263 Excessive build-up of distributed transaction locks (DX locks)
9.2.0.6 3576897 ORA-22804 inserting over a database link with select using CASE
9.2.0.6 3668077 "rollback to savepoint" in a distributed transaction dumps
9.2.0.6 3672097 Wrong results HASH join of CHAR / NCHAR over database link
9.2.0.6 3673561 READ_SCN may not advance even when there is no eager transaction
9.2.0.6 3676676 Ctrl-C/interrupt ignored for query over DB link
9.2.0.6 3688894 Dump (msqpfn) from PQ select with remote function
9.2.0.6 3700058 Rollback to a savepoint with a DB link can result in a full rollback
9.2.0.5 2276863 + CREATE FORCE VIEW against missing remote object may not work properly
9.2.0.5 2237763 ORA-980 using %ROWTYPE of SYNONYM pointing to remote table
9.2.0.5 2282825 MERGE with remote LOB may seem to work when it should fail
9.2.0.5 2303278 ORA-1874 / ORA-1882 using ALPHANUMERIC timezone and a DATABASE LINK
9.2.0.5 2329880 OERI:4412 OERI:4406 OERI:4886 can occur during CREATE PACKAGE with a DBLINK
9.2.0.5 2375503 Fetch from remote row source may be slow
9.2.0.5 2486767 ORA-1017 from database link using external authentication for main logon
9.2.0.5 2554178 CURRENT_SCHEMA signals ORA-1017 when the underlying object uses a DBLINK
9.2.0.5 2561115 SGA memory growth using outbound TCP/IP database links from shared servers
9.2.0.5 2671021 CTAS / create MVIEW of remote co-located complex subquery may perform slowly
9.2.0.5 2681080 INSERT over a DBLINK with a CASE EXPRESSION may throw ORA-22804
9.2.0.5 2717490 ORA-2055 when executing PLSQL in an 8i database updating 9i via a DBLINK
9.2.0.5 2843601 DML across a dblink fails with ORA-24370 if cursor_sharing is enabled
9.2.0.5 2870605 PLS-306 compiling a 9i procedure which references remote 8i/8.0 tables
9.2.0.5 2958096 Using XMLType / objects over DBLINKS with CURSOR_SHARING may dump
9.2.0.5 2976776 OERI:[qkarmtview20] can occur on UNION ALL select over a DB LINK
9.2.0.5 2980403 ORA-4045 / ORA-942 on first complete refresh of a materialized view using a DB LINK
9.2.0.5 2986643 Child cursors are not cached when executing SQL with a DB LINK when sql_trace=true
9.2.0.5 2991974 Storage for a BFILE is increased when copied via database link
9.2.0.5 3007574 OERI:15212 using CURSOR_SHARING=FORCE with database links
9.2.0.5 3039971 Shared server may dump (under niocto) if outbound DBLINK end point dies
9.2.0.5 3041166 Wrong results from SEMI JOIN with NL to remote table
9.2.0.5 3058463 Dump in kpcdrsz selecting ROWID from remote database from PLSQL
9.2.0.5 3066864 ORA-904 selecting from view over DB link if view has column alias in it
9.2.0.5 3070157 In subquery with remote mapped outer query may get poor plan
9.2.0.5 3071468 ORA-2019 may occur when describing an synonym using a database link
9.2.0.5 3076160 ORA-2080 when closing database links in PLSQL blocks
9.2.0.5 3077613 Dump inserting XMLType as a CLOB over a database link
9.2.0.5 3089249 Dump possible using binds over a DB link
9.2.0.5 3111598 CHAR columns not BLANK PADDED after CREATE MVIEW / refresh with different charsets
9.2.0.5 3124179 OERI:12333 possible over DB link with LONG type
9.2.0.5 3129934 Remote concatenated key joins may get poor execution plan
9.2.0.5 3157697 SYS_CONTEXT is not evaluated at primary site when used over a database link
9.2.0.5 3164195 Errors using TIMESTAMP WITH LOCAL TIMEZONE / TO_TIMESTAMP_TZ in PQO or over DB LINK
9.2.0.5 3204222 Wrong results from join of a remote table with EXISTS/IN query
9.2.0.5 3206107 ORA-3106 possible selecting from remote view via an 8i server
9.2.0.5 3240720 ORA-2019 using PRIVATE DB link owned by another user in PLSQL
9.2.0.5 3255452 OERI[rworupo.2] querying VARRAY attributes of remote objects
9.2.0.4 2117638 ORA-2063 / ORA-1445 possible from outer join over DB link with NULL sensitive predicates
9.2.0.4 2419335 OERI:[qks3tInit] possible from STAR transformation
9.2.0.4 2425679 Wrong results possible from select over DBLINK
9.2.0.4 2449247 ORA-4080 from XDB commiting changes in a distributed transaction
9.2.0.4 2526424 PLS-215 from 9i->8i PLSQL reference to view with zero length character column/s
9.2.0.4 2665478 OERI[RWORUPO.1] from INSERT .. SELECT over DBLINK with ADT column
9.2.0.4 2695242 ORA-22 OERI[18260] using MTS with shared DB links
9.2.0.4 2712141 Wrong results from HASH join of view on remote query block
9.2.0.4 2721462 ORA-7445 [KOPXCCC] from PLSQL RPC over DB LINK
9.2.0.4 2727446 Wrong results or ORA-904 from ANSI join between remote tables
9.2.0.4 2741185 Fast refresh of MV on remote LOB columns may hang
9.2.0.4 2758770 OERI:504 from Dispatcher/s when using TCP DB LINKS
9.2.0.4 2782196 ORA-3106 / OERI:729 after CTRL-C of INSERT..SELECT via a DBLINK
9.2.0.4 2836690 ROLLUP over DBLINK may fail with OERI:qks3tinit
9.2.0.4 2866419 ORA-1461 from SQL over DB link between different character sets
9.2.0.4 2876379 False ORA-24347 from INSERT over DB LINK between releases
9.2.0.4 2886505 Create database link may fail with ORA-32591
9.2.0.4 2888719 Wrong results from colocated remote tables with OUTER join
9.2.0.4 2894277 OERI[17200] accessing 9i -> 8i remote object with BFILE column from PLSQL
9.2.0.4 2905850 OERI[qkaRmtView20] possible from SELECT over DBLINK with local PLSQL function
9.2.0.4 3042342 Create database link may fail with ORA-32591
9.2.0.3 1829296 False ORA-980 from PLSQL referencing SYNONYM which uses a DBLINK
9.2.0.3 2374041 OERI[QERSQCLOSE-1] selecting REMOTE sequence from empty local table
9.2.0.3 2438953 OERI[KCBGCUR_2] / OERI[6856] from RECO in RAC/OPS
9.2.0.3 2448925 ORA-4030 from CTAS of CLOB over DBLINK from non_UTF8 -> UTF8
9.2.0.3 2452537 SELECT of remote sequence leaks cursors (ORA-1000)
9.2.0.3 2487248 Dump / memory corruption if Event 10129 is set for a distributed query
9.2.0.3 2490061 ORA-932 for remote SQL using TIMESTAMP datatype
9.2.0.3 2533616 Materialized view refresh can use lots of CPU
9.2.0.3 2533766 Wrong results from HASH JOIN over DBLINK between multibyte databases
9.2.0.3 2545840 Distributed query may see remote changes from AFTER the snapshot SCN
9.2.0.3 2567290 Large packet over DBLINK may fail with ORA-12539
9.2.0.3 2572944 SELECT over 8i -> 9i DBLINK may fail with ORA-7445 [opidsi]
9.2.0.3 2576353 ORA-7445[qxopqgcd] from remote query with user defined function
9.2.0.3 2599290 OERI from 8.0 client querying NULLs and LONG over 9i -> 9i DBLINK
9.2.0.3 2608776 ORA-3106 in 8.0 client SELECTing pseudo column from 9i server over DBLINK
9.2.0.3 2622558 XA Open option to close precompiler cursors on XA_END (avoid ORA-24779 errors)
9.2.0.3 2641473 OERI[OPIXRB-4] from V7 client binding SQLT_RID to 9.2 table over DBLINK
9.2.0.3 2658212 OERI:[KKCHBYT] possible with _keep_remote_column_size = TRUE
9.2.0.3 2694605 ORA-3118 possible when PLSQL executed over a DBLINK
9.2.0.3 2696120 OCCI client dump using connection pool and a database link
9.2.0.3 2698435 Repeated OERI:18260 / OERI:18186 if XA DBLINK errors at commit
9.2.0.3 2701820 OERI[18250] / dump using migratable database links
9.2.0.2 2043542 DATA_PRECISION incorrectly set to 38 for CTAS of SMALLINT over DBLINK
9.2.0.2 2073948 ORA-6550 possible referencing remote partitioned table after DDL performed on it
9.2.0.2 2254550 Enterprise user using shared schema passes wrong username over DBLINK
9.2.0.2 2255030 ORA-3106 possible from 8.0 client talking to 8i / 9i over a DBLINK
9.2.0.2 2267522 "INSERT INTO ... SELECT FUNC@LOOP" reports incorrect number of rows processed
9.2.0.2 2273417 RECO may not recover IN-DOUBT transactions when LOGON triggers exist
9.2.0.2 2309738 PLSQL SELECT over DB link throws unexpected error instead of ORA-1403 / no_data_found
9.2.0.2 2314238 VARCHAR2 Bind variables loose any TRAILING SPACES when used over a DATABASE LINK or bound dynamically
9.2.0.2 2314669 OERI:18090 using local functions with remote tables.

2.1.24 Datatypes (AnyData)

The following table lists the Datatypes (AnyData) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.4 1758854 ORA-22922 accessing CLOB attribute of ADT in AnyData

2.1.25 Datatypes (LOBs/CLOB/BLOB/BFILE)

The following table lists the Datatypes (LOBs/CLOB/BLOB/BFILE) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 5212539 + LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
9.2.0.8 2539368 ORA-12008 / ORA-1000 with MVIEW containing a CLOB with ON COMMIT REFRESH
9.2.0.8 2931779 False ORA-1555 accessing "cache read" LOBs in RAC
9.2.0.8 3219117 LOB SEGMENT uses more space with ASSM
9.2.0.8 3344331 OERI[504] can occur using INSTR on a LOB column
9.2.0.8 3448802 Exp / Imp / view problems if LOB tablespace blocksize different to table blocksize
9.2.0.8 3493456 Large LOB data is not applied correctly when running logical standby
9.2.0.8 3900290 Excessive memory spill in Streams for DDL transactions with LOB DMLs
9.2.0.8 4113930 Space reclaimation shows HW enqueue contention with concurrent insert of LOBs
9.2.0.8 4195693 LOB segment space in an ASSM tablespace is not reused effectively
9.2.0.8 4198000 ORA-22993 / unreadable LOB data with temp CLOB
9.2.0.8 4207520 DBMS_SPACE.SPACE_USAGE gives wrong results for ASSM LOB segment
9.2.0.8 4224765 REPLACE on a CLOB spins in kole_simple_string_match
9.2.0.8 4278912 ORA-24852 if cursor selecting BLOB is rebuilt
9.2.0.8 4280096 High buffer gets for insert into lob
9.2.0.8 4303122 Temporary lob is not reused when PLSQL calls Java in a loop
9.2.0.8 4387452 ORA-22922 trying to DEREF an object view
9.2.0.8 4401000 OERI[16608] during import of transportable tablespace
9.2.0.8 4431195 Temporary lob leak during domain index sync operations
9.2.0.8 4431273 LOB segment PCTVERSION space reclaimation wrong
9.2.0.8 4559728 Select lob from view loops / OERI [17059] if synonym dropped
9.2.0.8 4634368 Performance issues with LOBs during reclaimation
9.2.0.8 4642825 ORA-22922 "non existant lob value" from incomplete bulk fetch
9.2.0.8 4748597 Moving a LOB in a partitioned table fails to update IND$
9.2.0.8 5011764 OERI[ktsircinfo_num1] accessing a LOB
9.2.0.8 5017007 MVIEW LOB content incorrect after refresh
9.2.0.7 2649958 Analyze table with functional index on LOB column gets no statistics for the index column
9.2.0.7 3419707 Varying width CLOB data padded with blanks over database link
9.2.0.7 3537749 HW enqueue contention when loading lob data
9.2.0.7 3772033 OERI[ktspfmb_create1] creating a LOB in ASSM using 2k blocksize
9.2.0.7 3774546 OCILobRead may dump in kghalo() if there is character set conversion
9.2.0.7 3794969 BFILE locator takes up maximum length rather than actual length
9.2.0.7 3795386 Insert as select of LOBS / XMLType across DB Link can leak memory
9.2.0.7 3796939 Hang on rebind/reexecute of SQL with more than on LOB column over 4K long
9.2.0.7 3903575 OERI[kolaslRead-2] during LOB read of XML
9.2.0.7 4047608 Export/import can loose the LOGGING attribute of LOB columns
9.2.0.7 4052219 LOB segment may leak space when ASSM managed
9.2.0.7 4063046 Latch contention due to leaked CR pins for LOB data
9.2.0.7 4096261 Missing direct loaded LOB data in Streams
9.2.0.7 4122275 Update of partitioned table with LOB may dump with concurrent TRUNCATE of partition
9.2.0.7 4140264 ORA-3117 can occur during replication push for NULL BLOB columns
9.2.0.7 4305391 OERI[25012] with kditalp can occur during a temporary LOB operation
9.2.0.7 4369117 OCI direct path out-of-line LOB insert slow
9.2.0.6 3544995 + LOB segments with "CACHE READS" generate no REDO even with the logging option
9.2.0.6 2256943 Dump (in kohalw) selecting TEMPORARY LOB over a DBLINK
9.2.0.6 2380066 Temporary LOB performance degrades with ADTs
9.2.0.6 2660148 LOB Index extent sizes may be larger than expected
9.2.0.6 2810530 ORA-22285 from DBMS_LOB.LOADFROMFILE
9.2.0.6 2840895 ORA-22921 inserting into remote CLOB with varying width characterset
9.2.0.6 3127987 NCLOB data is corrupted after insert through JDBC
9.2.0.6 3163264 Dump / memory corruption at logical standby for LOB table with trailing nulls
9.2.0.6 3166756 Self deadlock (ORA-60) possible on LOB index update
9.2.0.6 3194872 Using TEMP CLOB in TABLE function may fail with ORA-22922
9.2.0.6 3263671 ORA-2019 from INSERT INTO .. SELECT from remote LOB using a PUBLIC synonym
9.2.0.6 3288625 ORA-22621 / OERI:kopuigpfx1 using LOBs in OCI Extproc
9.2.0.6 3291851 EXP-3 exporting LOB from 9205 or higher DB with <9205 export
9.2.0.6 3309296 The retention value of a partitioned LOB is always 0
9.2.0.6 3310330 Select with ORDER BY over HS fails when table has long/blob datatype
9.2.0.6 3313274 Direct path load of LOBs can cause data loss/truncation in streams
9.2.0.6 3361118 OERI:[7999] / LOB corruption updating a LOB in a SERIALIZABLE transaction
9.2.0.6 3446987 OERI[19942] after TRANSPORTING a TABLESPACE containing LOBS (converted from LONGS)
9.2.0.6 3477127 Dump (kollgsz) when OCIStmtFetch2 fetches a NULL CLOB
9.2.0.6 3492211 ORA-23308/ora-23309 replicating pre-created tables with LOB
9.2.0.6 3498315 Insert CLOB datatype from single-byte database to UTF8 hangs
9.2.0.6 3527223 OERI:kokegPinLob1 from SELECT with ORDER BY on table with CLOB
9.2.0.6 3532017 OERI:kokegPinLob1 possible inserting CLOB from 10g to 9.2
9.2.0.6 3556570 "select length(foo()) ..." leaks temp LOBs between rows
9.2.0.6 3602321 Streams/logminer cannot handle partial rollback of a failed BULK BIND operation on a table with LOBS
9.2.0.6 3686945 Long CLOB data not updated correctly with LOB buffering in multibyte DB
9.2.0.5 2282825 MERGE with remote LOB may seem to work when it should fail
9.2.0.5 2735268 If OCILobCreateTemporary fails it may return the wrong error
9.2.0.5 2784201 OERI:[ktspfupdst-1] on INSERT into LOB after TRUNCATE with ASSM
9.2.0.5 2842621 LOB DML failure can lead to corrupt LOB data at APPLY site
9.2.0.5 2861835 Streams apply may contain direct loaded LOB data which was rolled back
9.2.0.5 2868068 Streams apply can fail with ORA-1403 when LOB DMLs are rolled bac
9.2.0.5 2926182 OERI[25027] / ORA-22922 accessing LOB columns in IOT in AFTER UPDATE trigger
9.2.0.5 2991974 Storage for a BFILE is increased when copied via database link
9.2.0.5 3019979 Space may not be reused efficiently in a LOB segment
9.2.0.5 3027676 OCILobRead callback in UTF8 may fail with ORA-24812
9.2.0.5 3029292 LOB corruption possible on ASSM tablespace
9.2.0.5 3054794 UPPER/LOWER of CLOB may dump in kole_case
9.2.0.5 3058923 Memory corruption possible using LOBs in IOTs
9.2.0.5 3071475 Export writes bad DDL for user defined types stored as LOBs
9.2.0.5 3075483 ORA-22921 using UPPER or LOWER on a CLOB column in multibyte (eg: UTF8) in PLSQL
9.2.0.5 3077651 LOB manipulation can leak "buffer" state objects causing hangs/shared pool problems
9.2.0.5 3091499 Bad export / import dumps for table with LOB CHUNKSIZE = 32K
9.2.0.5 3107254 Data truncation after redefine when fetching a LOB in Pro/OCI
9.2.0.5 3110501 OERI:[kdlfkd-7] possible on stream write to a LOB segment
9.2.0.5 3131199 Core dump possible during LOB read on XML data
9.2.0.5 3213101 Lob corruption / ORA-1555 can occur on a LOB segment in ASSM
9.2.0.5 3234751 Excessive TEMP space usage from SQLLDR of LOBS or INSERT .. RETURNING with LOBS
9.2.0.5 3291851 EXP-3 exporting LOB from 9205 or higher DB with <9205 export
9.2.0.4 2944866 * Free space in LOB table / tablespace not reused with ASSM. This bug is alerted in Note:250525.1
9.2.0.4 1615764 ORA-22922 accessing TEMP LOB in a REF CURSOR returned from PLSQL
9.2.0.4 2643723 ORA-1555 possible using AUTO space managed LOB segments
9.2.0.4 2708441 ORA-22275 using RETURNING CLAUSE for UPDATE of LOB
9.2.0.4 2726398 OERI:kokegPinLob1 from VIEW with EXPRESSION on a CLOB column
9.2.0.4 2741185 Fast refresh of MV on remote LOB columns may hang
9.2.0.4 2767857 SQLLOAD of NULL LOB loads previous LOB value
9.2.0.4 2774862 Dump (under ktspfpblk) can occur when writing to a LOB
9.2.0.4 2777612 ORA-22922 getting length of temporary LOB on client
9.2.0.4 2847512 Temp LOB leak in DBURITYPE.GETBLOB()
9.2.0.4 2894277 OERI[17200] accessing 9i -> 8i remote object with BFILE column from PLSQL
9.2.0.4 2919655 LOBs may not reuse space with automatic undo management
9.2.0.4 3001947 Capture dumps transforming out of line LOB
9.2.0.3 2642117 * Overflow vulnerability in DIRECTORY parameter of BFILENAME. This bug is alerted in Note:229284.1
9.2.0.3 2645378 + LOB data corruption after RECOVERY
9.2.0.3 2448925 ORA-4030 from CTAS of CLOB over DBLINK from non_UTF8 -> UTF8
9.2.0.3 2495123 PLS-306 using DBMS_LOB.LOADFROMFILE after upgrade to 9.2
9.2.0.3 2506655 ORA-22921 using REPLACE() on a CLOB in PLSQL in UTF8
9.2.0.3 2529036 LIKE against multi-byte CLOB can give wrong results
9.2.0.3 2537320 SQL_REDO for large LOB operations is not executable
9.2.0.3 2541038 Streams / Logical standby get corrupt/missing data for row migrated partitioned LOB columns
9.2.0.3 2544428 Export may write bad LOB storage clause for TRANSPORT (ORA-22850 on IMPORT)
9.2.0.3 2563206 CLOB data is corrupted when inserted from an 8.0 client to multibyte 9.2 server
9.2.0.3 2586762 Direct LOB reads can result in ORA-4031 / excessive shared pool usage
9.2.0.3 2644285 OERI:2652 from LOB update with supplemental logging
9.2.0.3 2656036 OERI/memory corruption selecting SQL_REDO for CLOB DMLS
9.2.0.3 2656881 LOB data corrupt after migrating DB from single -> multibyte
9.2.0.3 2685942 OERI/dump possible minig LOB redo
9.2.0.3 2695425 CONVERT() CLOB to a multibyte characterset gives corrupt result
9.2.0.3 2702872 Unnecessary library cache pin / lock activity during LOB reads
9.2.0.2 1785175 OERI:kcbgcur_9 from CLOB TO CHAR or BLOB TO RAW conversion
9.2.0.2 1818720 Dump with PLSQL and Java Stored Procedure returning NULL CLOB
9.2.0.2 2166798 ORA-3124 inserting NULL into CLOB with UTF8 characterset
9.2.0.2 2168939 ORA-932 / DUMP on INSERT with INSTEAD OF TRIGGER on LOB/OBJECT column
9.2.0.2 2193313 PLSQL CreateAbstractClob() dumps if LOB not freed
9.2.0.2 2207959 Dump from COALESCE of PARTITIONED table with LOB
9.2.0.2 2210922 OERI:[kola_set_locator-2] from string operations on virtual CLOB
9.2.0.2 2234325 ALTER partitioned table with global FUNCTIONAL index and LOBS dumps in kkfiSetMemRep
9.2.0.2 2242146 Inserting a virtual LOB into a LOB column dumps
9.2.0.2 2255864 ABSTRACT LOB does not support multibyte data
9.2.0.2 2258881 Unexpected ORA-22922 possible using TEMP LOBS
9.2.0.2 2322759 DBMS_LOB.READ can leak "koh-kghu call" heap memory
9.2.0.2 2326066 OERI[ktspffbmb-4] creating LOB column in AUTO SEGMENT SPACE MANAGEMENT
9.2.0.2 2329551 OERI [kcbgcur_6] after EXCHANGE PARTITION on IOT with LOBS
9.2.0.2 2334318 ORA-942 accessing LOB through VIEW WITH CHECK OPTION
9.2.0.2 2346568 ORA-22921 comparing CLOBS from different character sets
9.2.0.2 2367256 Fix for Bug:2133357 not in Oracle9i (Corrupt LOBS after altering DB characterset)
9.2.0.2 2396270 FAILOVER: ORA-25401 after failover when fetching CLOB data
9.2.0.2 2405258 Dictionary corruption / OERI:15265 from MOVE LOB to existing segment name
9.2.0.2 2466076 DBMS_LOB.LOADCLOBFROMFILE() may dump for AL16UTF16 data
9.2.0.2 2475163 Privilege errors modifying LOB in an ADT via a view

2.1.26 Datatypes (Objects/Types/Collections)

The following table lists the Datatypes (Objects/Types/Collections) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2606632 Insufficient privileges error after user is granted all on nested table column
9.2.0.8 2742598 Object types with circular references are not exported if not used in table
9.2.0.8 2844111 DBMS_METADATA gives wrong DDL for PLSQL objects with embedded comments
9.2.0.8 3518579 Table mode export does not export parent type
9.2.0.8 3936576 Dictionary corruption modifying ADT column to NOT SUBSTITUTABLE
9.2.0.8 3983923 Export of a partition with a nested table column exports all nested table rows
9.2.0.8 4035664 ORA-932 or ORA-904 from CAST in SQL statement in a PLSQL block
9.2.0.8 4044798 Dump (kkdcgkc) from DML dereferencing scoped REFs
9.2.0.8 4046842 Table level export/import can produce corrupt TYPE metadata
9.2.0.8 4060287 Memory leak in OCCI object column with object attribute
9.2.0.8 4068481 ALTER TABLE to add a nested table column to a partitioned table uses wrong tablespace
9.2.0.8 4121749 ORA-21779 / dump using TABLE functions / BULK collect
9.2.0.8 4186247 Bad export / IMP-8/IMP-9 when importing long user defined types
9.2.0.8 4242649 Object views are slower than they need be
9.2.0.8 4331352 Wrong results with nested tables and outer queries
9.2.0.8 4352808 Dump (kglpnal) / OERI:17252 / crash from PQ with TYPE columns
9.2.0.8 4387452 ORA-22922 trying to DEREF an object view
9.2.0.8 4431181 Dump from SELECT if it changes from remote mapped to not
9.2.0.8 4583492 Dump possible using ADT columns when table has many columns
9.2.0.8 4860003 Sqlplus dump / OCI-21500 [koxsihread1]
9.2.0.8 4873171 TYPEID does not match after recreate of type
9.2.0.8 4959569 OERI[kdic_create_journal_table_1] rebuilding REF index ONLINE
9.2.0.7 2339943 Query using OR between two subtypes returns a wrong number of rows
9.2.0.7 2484985 Dump from anti or semi joins involving collections
9.2.0.7 2630783 Dump occurs inserting a VARRAY with 65535 elements
9.2.0.7 2892189 Dump updating columns in a nested table with a trigger on the table
9.2.0.7 3100625 A view involving a collection (CAST/MULTISET) may return wrong results
9.2.0.7 3231200 OERI[kokqaguco1] possible using OBJECTS
9.2.0.7 3332184 Session using objects may dump [kocdsgt]
9.2.0.7 3411348 OERI[kksfbc-reparse-infinite-loop] / dump [kksfbc] after ALTER TABLE .. UPGRADE
9.2.0.7 3513629 Dump (vopqbc) from query with OLS and CAST(MULTISET())
9.2.0.7 3516231 SELECT from a view with a TABLE function may dump
9.2.0.7 3554248 Dump [nsoexc] from CTAS with more than one TABLE operator
9.2.0.7 3744836 ORA-4043 on SYS_PLSQL_%s_%c from DROP of a versioned object
9.2.0.7 3810088 Cannot drop a table with a TYPE with associated user statistics
9.2.0.7 3819011 OERI[23050] on DML against a table with OBJECT columns in a replication group
9.2.0.7 3831897 No rows from query against nested table view column when multiply referenced
9.2.0.7 3895546 Capture may dump after certain DDLs
9.2.0.7 3946544 EXP-62 if the header of a wrapped TYPE contains a comment
9.2.0.7 3984620 Dump if type name identifier undergoes character set conversion
9.2.0.7 4007071 Wrong results selecting from TABLE() collection
9.2.0.7 4015652 Nested Table export fails with ORA-1007
9.2.0.7 4204326 Cursors with TABLE() expressions no shared when USE_STORED_OUTLINES set
9.2.0.6 2270510 IMP-58 / ORA-22337 importing evolved type object table
9.2.0.6 2380066 Temporary LOB performance degrades with ADTs
9.2.0.6 2392650 ORA-22324 / ORA-22328 / OERI:koputilcvto2n on ALTER TYPE to add an ATTRIBUTE
9.2.0.6 2445596 ORA-30746 / OERI:kkdoicst1 when DROP subtype validate with pk-based OID
9.2.0.6 2557089 OCI-21500 [kope2upic954] querying ADT
9.2.0.6 2669061 ORA-1007 exporting table with VARRAY
9.2.0.6 2711453 CONNECT BY on a collection type may return wrong results or no rows
9.2.0.6 2816062 Wrong result when using '+' as outer join on indexed REF column
9.2.0.6 2914804 OERI:[kokbnp2] executing method in schema with same name as an object
9.2.0.6 2929029 Wrong results comparing a REF type with != or <> in the WHERE clause
9.2.0.6 3156820 ORA-23309 during CREATE_MASTER_REPOBJECT or table with OBJECT columns as LOBs
9.2.0.6 3194872 Using TEMP CLOB in TABLE function may fail with ORA-22922
9.2.0.6 3230967 ORA-979 from complex view merge with TABLE() on outer query block
9.2.0.6 3248893 OERI [17285] possible if TABLE() function invalidate
9.2.0.6 3276952 Export / import of nested table from dictionary to locally managed tablespace fails
9.2.0.6 3278020 ORA-942 creating MVIEW across dblink from 9i to 8i for object table
9.2.0.6 3342768 Dump performing a hierarchical query on an inline view with a TABLE clause
9.2.0.6 3385076 Complex object retrieval may fail with OCI-21700
9.2.0.6 3402567 OERI[koputilcvto2n: 2] during ALTER TABLE for object table
9.2.0.6 3430870 ALTER TYPE of self referencing type body generates PLS-565 with trailing comments
9.2.0.6 3455357 OERI:voprvl1 can occur using TABLE() with OLS installed
9.2.0.6 3465087 ORA-905 possible from CAST() over DB link if "AT" clause is a column name
9.2.0.6 3476435 OERI:koksadqb2 compiling a package containing CAST(MULTISET(collection subquery)))
9.2.0.6 3545642 Wrong result when using LEFT OUTER joins and TABLE() operator
9.2.0.6 3546174 OERI[kcbgtcr_1] from subquery unnesting of a subquery containing a TABLE() function
9.2.0.6 3625129 OERI[kopp2upic#329] possible querying a nested table
9.2.0.6 3786302 ANSI join with correlated TABLE() clause fails (ORA-904)
9.2.0.5 3124536 I XML related objects may be invalidated on applying a 9.2 Patch Set
9.2.0.5 2167574 DEQUEUE fails with OERI:kodrsobj1 when PAYLOAD is NON-FINAL object
9.2.0.5 2314382 NUMBER precision missing for VIEW of a table expression
9.2.0.5 2503821 OERI:[QCTCFX:LEN] compiling PLSQL with nested table DML
9.2.0.5 2570545 Queries after a 'DROP SUBTYPE VALIDATE' can fail with ORA-21700
9.2.0.5 2684113 Dump in kkqsvopn when using ADT binds in INSTEAD OF triggers
9.2.0.5 2782260 Duplicate rows in USER_TYPE_METHODS after ALTER TYPE ADD/DROP ATTRIBUTE
9.2.0.5 2833543 Dump during multi-table insert into object table with subtypes
9.2.0.5 2906041 Dump selecting from object view using UNIONed object tables
9.2.0.5 2908421 Dump (koxsisz) when OCIStmtFetch2 fetches a NULL collection
9.2.0.5 2941050 OERI[6302] when creating index on table containing a NULL REF column
9.2.0.5 2950591 Spin manipulating complex object in PLSQL
9.2.0.5 2950839 OERI[kokeicssadd2] using Opaque types
9.2.0.5 2964015 Altering a type may dump
9.2.0.5 2971220 ORA-932 possible from TABLE() function in a UNION clause
9.2.0.5 2988739 OERI[kopp2upic#329]/OERI:kokeaai5 with FINAL supertype and NOT FINAL subtype
9.2.0.5 2996728 ORA-932 querying REF after changing an attribute of REFed object type
9.2.0.5 3031024 Export of object types and many subtypes produces bad export file (OCI-22303 on import)
9.2.0.5 3041342 Bad DDL in export file exporting a table which is not substitutable at all levels
9.2.0.5 3041387 OERI[kopi2_readlen083] enqueuing object with immediate embedded NULL
9.2.0.5 3042541 Spin possible processing subtypes
9.2.0.5 3042674 Wrong results on ANSI object queries / XDB "extract" operations may dump (evaopn2)
9.2.0.5 3063104 Dump under qervwFetch selecting ROWID from a view based on a collection iterator
9.2.0.5 3063241 Poor execution plan possible for semi join with collection iterator
9.2.0.5 3071475 Export writes bad DDL for user defined types stored as LOBs
9.2.0.5 3085651 Table corruption / OERI after TRUNCATE on ASSM table with NESTED TABLE cols
9.2.0.5 3090963 OERI[kocgpn129] / Dump in kocgpn2 can occur
9.2.0.5 3091504 Updating object with varray attribute may dump / corrupt memory
9.2.0.5 3091807 Dump with multi-level collections over views
9.2.0.5 3093454 A query with TABLE() may ORA-979 in PLSQL
9.2.0.5 3113983 MAP methods with invokers rights run as DEFINERS rights
9.2.0.5 3118399 Dump in koktupd_dplvl from ALTER TYPE with a cyclic dependency
9.2.0.5 3138341 Wrong datatypes returned from PLSQL REF Cursor using CAST
9.2.0.5 3150037 Export may produce wrong SQL for CREATE TABLE xxx OF typename
9.2.0.5 3163361 SELECT rowid from an object type dumps
9.2.0.5 3170681 Memory corruption / Dump kghispih() using Objects
9.2.0.5 3184705 OERI[kopp2pic798] from SELECT on OBJECT table with large number of rows returned
9.2.0.5 3192983 Problems upgrading a table containing VARRAYS of REFS to an evolved type
9.2.0.5 3208473 Dump in kopi2fmt81ch processing 8i objects in 9i
9.2.0.5 3227302 Query rewrite does not occur in 9i when table contains a VARRAY column
9.2.0.5 3255452 OERI[rworupo.2] querying VARRAY attributes of remote objects
9.2.0.5 3256861 Dump in atbiauxtab during ALTER TYPE ADD ATTRIBUTE with underlying IOT
9.2.0.5 3258506 DBA|ALL|USER_TYPE_ATTRS does not show REF attribute after ALTER TYPE
9.2.0.5 3261807 ORA-932 after ALTER TYPE of a sub type
9.2.0.5 3267327 OERI[koputilcvto2n] on "alter table .. upgrade" command
9.2.0.5 3288190 Problems with Objects
9.2.0.5 3296778 SELECT may fail with ORA-932 after an ALTER TYPE
9.2.0.5 3298034 utlrp.sql attempts to re-validate old versions of types
9.2.0.4 1758854 ORA-22922 accessing CLOB attribute of ADT in AnyData
9.2.0.4 2363698 ORA-1793 creating functional index on XML (or object) columns
9.2.0.4 2474232 Dump in kksmal0 selecting object and rowid data
9.2.0.4 2496699 Poor performance selecting from OBJECT TABLE with REFS
9.2.0.4 2588285 ALTER TABLE MOVE of table containing REFs may dump
9.2.0.4 2665478 OERI[RWORUPO.1] from INSERT .. SELECT over DBLINK with ADT column
9.2.0.4 2708284 Loader misreads secondary datafiles for VARRAYs / Nested Tables
9.2.0.4 2731243 False ORA-979 from scoped REFS in GROUP BY / ORDER BY
9.2.0.4 2749361 Create DOMAIN INDEX fails on SUBTYPED OBJECT
9.2.0.4 2758168 ORA-7445 [KOKEIS] on REFRESH of remote MVIEW with VARRAY and TRIGGER
9.2.0.4 2802560 SETID index not created automatically for nested table in an IOT
9.2.0.4 2856475 OCITypeArrayByName dumps if passed in type has been dropped and schema is null
9.2.0.4 2860984 Bad plan possible with collection iterator (table/Cast)
9.2.0.4 2862818 Bad export of NESTED table in LOCALLY managed tablespace - ORA-25150 / ORA-942 on import
9.2.0.4 2881337 OERI:17011 on ALTER TABLE RENAME with user defined type column
9.2.0.4 2924041 No rows may be returned when VIEW column is defined on CAST / MULTISET
9.2.0.3 2697938 + UPDATE of object table sets columns to NULL with index only access
9.2.0.3 1584155 DROP FORCE/RECREATE TYPE with DEPENDENCIES corrupts dictionary information
9.2.0.3 1955577 Dump (in KOKEIS) using BINDS if TRIGGER updates nested table column
9.2.0.3 2040114 OERI:[qcsrlidm1] from predicate with TYPE MEMBER method call
9.2.0.3 2234028 CREATE TABLE OF <TYPE> AS SELECT can produce invalid table data
9.2.0.3 2261722 8i export of 9i database dump (in koputilassert) with SUBTYPE / NOT FINAL type
9.2.0.3 2347596 Transport of OBJECT table may get index in wrong tablespace
9.2.0.3 2448939 OCICacheFlush stores objects as the base type instead of the SUBTYPE
9.2.0.3 2476514 ORA-22324 / OERI:[4883] adding method to OBJECT with REF dependencies
9.2.0.3 2479354 Direct path load of column Objects give wrong results / dumps
9.2.0.3 2551568 OERI:[rworupo.1] / wrong results from queries involving OBJECTS
9.2.0.3 2564693 ORA-22813 from CAST(MULTISET(...))
9.2.0.3 2599613 IMP-60 possible when object already exists in database
9.2.0.3 2614464 ORA-979 from PLSQL query with TABLE() function and PLSQL bind in the GROUP BY clause
9.2.0.3 2628768 ORA-922 possible with OVERFLOW and VARRAY clauses on an object IOT
9.2.0.3 2658284 OERI:[QERPFFETCH1] possible during OBJECT table BULK SELECT
9.2.0.3 2732590 Creating complex types with SUB TYPES in NOT FINAL MODE may dump (kopocue)
9.2.0.2 1532054 ORA-604 / ORA-600 / Dump possible referencing TYPE in TABLE() clause
9.2.0.2 1779188 OCI-21500 on SELECT of a FINAL ADT with an embedded non FINAL collection
9.2.0.2 1788639 OERI:4882 from CREATE MATERIALIZED VIEW on OBJECT table
9.2.0.2 1831941 OERI:koktcntv1 on ALTER TYPE when it has been recreated in another session
9.2.0.2 1889003 ORA-30757 on query view hierarchy if user has no privilege on a SUBTYPE
9.2.0.2 1941831 EXECUTE IMMEDIATE of CALL type constructor dumps in kkxmstcs
9.2.0.2 2064478 CREATE or REPLACE TYPE BODY can fail with OERI:[QCSRWAE1]
9.2.0.2 2158358 ORA-1062 SELECTing a NULL REF from an OBJECT view
9.2.0.2 2168939 ORA-932 / DUMP on INSERT with INSTEAD OF TRIGGER on LOB/OBJECT column
9.2.0.2 2193493 VARRAYs with embedded SUBSTITUTABLE TYPE may dump
9.2.0.2 2204827 ORA-22905 on GRANT against VIEW using TABLE() function
9.2.0.2 2211047 ORA-7445 [QCSPOBY] possible from CAST/MULTISET on subquery with ORDER BY
9.2.0.2 2222308 Dump in qcsfoep() on CREATE TYPE BODY which references unqualified PLSQL function
9.2.0.2 2223449 ORA-29925 / ORA-932 from DML against table with functional DOMAIN index on ADT expression
9.2.0.2 2225569 OERI:KOKBNP2 possible parsing CURSOR() expression
9.2.0.2 2226328 Dump in nsoexc() on SELECT from VIEW with OBJECTS and CONNECT BY
9.2.0.2 2232548 VARRAY number columns are not rounded / truncated
9.2.0.2 2243589 Dump in KOKEIOD2M using NESTED TABLE columns in OUTER joins
9.2.0.2 2246137 ArrayIndexOutOfBoundsException in oracle.jdbc.oracore.UnpickleContext.read_lengthBytes after changing between 32<->64 bit
9.2.0.2 2259466 PLSQL: Assigning one VARRAY to another produces corrupt VARRAY - ORA-6533 / OERI:KOPE2_READSTR232
9.2.0.2 2267728 OERI:[KOHCPI298] from TRUSTED CONSTRUCTOR function that returns a NULL ADT
9.2.0.2 2295440 Dump referencing ROWID when using TABLE() in an inline view
9.2.0.2 2300104 CREATE VIEW OF TYPE .. UNDER .. does not export the UNDER clause
9.2.0.2 2309579 OERI:kokeicd2m1 on multi-table INSERT with an out-of-line column
9.2.0.2 2316195 OCI with COLLECTION may dump on OCIObjectFlush / OCITransCommit
9.2.0.2 2349201 ORA-1647 importing TRANSPORTABLE set with partitioned object table
9.2.0.2 2360357 ORA-2304 on CREATE OR REPLACE TYPE with OID
9.2.0.2 2364710 OERI [12868] possible on DROP USER when GRANT exists on ALTERED TYPE
9.2.0.2 2380475 Dictionary corruption from CREATE OR REPLACE SYNONYM on TYPE
9.2.0.2 2381566 Large UPDATE of NESTED TABLE column shows excessive memory use
9.2.0.2 2385206 OERI:723 possible after ORA-22813 error on objects
9.2.0.2 2389429 ALL_COLL_TYPES may omit rows
9.2.0.2 2391730 OERI:[KOTDATV5] evolving a type already evolved in another session
9.2.0.2 2396474 ORA-7445 [KOXSS2GPAGE] querying inline view with aggregate on OBJECT column
9.2.0.2 2430504 Dump selecting from table with VARRAY and VPD policy
9.2.0.2 2475163 Privilege errors modifying LOB in an ADT via a view
9.2.0.2 2508513 ORA-22813 / OERI:723 with large objects/collections

2.1.27 Datatypes (TIMESTAMP)

The following table lists the Datatypes (TIMESTAMP) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2490569 Logminer may mishandle TIMESTAMP columns with implicit time zone
9.2.0.8 4197704 OERI:7005 from queries involving partitions and TIMESTAMPs
9.2.0.8 4237890 %TYPE of a timestamp in a union all view has the wrong precision
9.2.0.8 4417371 TIMESTAMP columns loose fractional seconds in PQ
9.2.0.8 4708037 ORA-904, ORA-2063 from query that uses TIME ZONE as a cast
9.2.0.8 4776636 Wrong value for TIMESTAMP WITH TIME ZONE when NLS_CALENDAR set
9.2.0.8 4914281 TIMESTAMP WITH TIMEZONE values before 1800 corrupted
9.2.0.7 2616238 Unparse of TIMESTAMP conversions not supported
9.2.0.7 3390566 OERI / dump from functional indexes on TIMESTAMP columns
9.2.0.7 3756943 Corrupt date when SYSDATE is defined as TIMESTAMP
9.2.0.6 3141614 TIMESTAMPs can get wrong data if fraction of seconds is >9 digits long
9.2.0.6 3144878 oracle.sql.TIMESTAMP is not serializable
9.2.0.6 3222472 HS TIMESTAMP implementation does not allow fractions of a second
9.2.0.5 2422838 Fetching a "TIMESTAMP with LOCAL TIMEZONE" column into SQLT_TIMESTAMP_LTZ gives wrong results
9.2.0.5 2501229 Redefines using SQLT_TIMESTAMP_TZ get wrong results / dump
9.2.0.5 2630914 TIMESTAMP may be converted incorrectly for date format 'dd-mon-rrrr'
9.2.0.5 2864062 TIMESTAMPLTZ(..,TIMESTAMP) failw with non default SESSION TIMEZONE
9.2.0.5 2963428 Incorrect dates possible using TIMESTAMP WITH LOCAL TIMEZONE
9.2.0.5 3116276 TRUNC/ROUND error for TIMESTAMP parameters
9.2.0.5 3164195 Errors using TIMESTAMP WITH LOCAL TIMEZONE / TO_TIMESTAMP_TZ in PQO or over DB LINK
9.2.0.5 3170997 OERI[kdic_create_journal_table_1] from rebuild index online with TIMESTAMP
9.2.0.4 2547402 OERI[KDIC_CREATE_JOURNAL_TABLE_1] from REBUILD index ONLINE of TIMESTAMP key column
9.2.0.4 2858755 OCCI client dumps fetching TIMESTAMPS from REF CURSOR
9.2.0.3 2227982 OCIIntervalSetYearMonth() may produce ORA-1873 errors
9.2.0.3 2460091 ORA-7445[pgmbiad_build_input] if PLSQL calls Java callout with a TIMESTAMP parameter
9.2.0.3 2490061 ORA-932 for remote SQL using TIMESTAMP datatype
9.2.0.3 2601203 ORA-3106 from INSERT .. RETURNING a NULL into a TIMESTAMP column
9.2.0.2 2269285 OERI:[QCTVCO : BFC] INSERTing '' to table with TIMESTAMP column & trigger
9.2.0.2 2286804 Incorrect timezone conversion for some TIMESTAMPs for certain zones
9.2.0.2 2339030 :OLD / :NEW contain garbage for TIMESTAMP WITH LOCAL TIMEZONE columns
9.2.0.2 2420305 ORA-26041 from Direct path load of TIMESTAMP data on EBCDIC

2.1.28 Deadlock

The following table lists the Deadlock bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3987280 Concurrent GRANT / SET ROLE can hang / deadlock
9.2.0.8 4029101 Concurrent CREATE TABLE can deadlock (ORA-60)
9.2.0.8 4114238 Deadlock between dc_users and dc_usernames row cache lock enabling FK
9.2.0.8 4153150 Deadlock on dc_rollback_segments from concurrent parallel load and undo segment creation
9.2.0.8 4185270 PMON "failed to acquire row cache enqueue" cleaning a dead process
9.2.0.8 4275733 Deadlock between library cache lock and row cache lock from concurrent rename partition
9.2.0.8 4313246 PLSQL execution can hold dc_users row cache lock leading to hang / deadlocks
9.2.0.8 4329748 ORA-4020 / deadlock quiescing a replication group
9.2.0.8 4371923 SMON may deadlock on TX enqueue waits for updates to COL_USAGE$ in RAC
9.2.0.8 4416907 ORA-4020 from DO_DEFERRED_REPCAT_ADMIN with concurrent SQL
9.2.0.8 4446011 Hang with row cache lock deadlock from concurrent ALTER USER / TRUNCATE
9.2.0.8 4627237 autonomous_transaction with DB link to shared server can self deadlock on DX
9.2.0.8 4732503 Self-deadlock on TT enqueue
9.2.0.8 4768022 ALTER TABLE can fail with ORA-60
9.2.0.8 5012368 Undetected deadlock in RAC
9.2.0.7 2883771 "WAITED TOO LONG FOR ROWCACHE ENQUEUE" when using Resource Manager in PLSQL
9.2.0.7 3261205 Hang / OERI[kxttdropobj-1] on parallel direct load to temporary table
9.2.0.7 3314850 DROP SUMMARY can deadlock with query rewrite sessions
9.2.0.7 3641819 Undetected deadlock possible in RAC
9.2.0.7 3777178 TA / US enqueue deadlock during transaction recovery in RAC
9.2.0.7 3896974 ORA-4020 creating DIMENSIONs from schemas simultaneously
9.2.0.7 3992847 Deadlocks are not detected in rac when one node rebooted more recently than the rest
9.2.0.7 4220161 Deadlock between SMON processes on different instances
9.2.0.6 2014833 Deadlock possible from concurrent SELECT and TRUNCATE
9.2.0.6 2615271 Deadlock from concurrent GRANT and logon
9.2.0.6 3166756 Self deadlock (ORA-60) possible on LOB index update
9.2.0.6 3268802 Additional diagnostics for deadlock in RAC environment
9.2.0.6 3320292 Parallel recompilation hangs when recompiling type generated for pipeline function
9.2.0.6 3381218 Deadlock involving 'library cache lock' X mode request
9.2.0.6 3398485 Deadlock during on demand materialized view refresh (ORA-4020)
9.2.0.6 3424721 Hang/deadlock from ALTER INDEX REBUILD on partition with concurrent SQL
9.2.0.6 3562032 Cancelled ONLINE index rebuild can deadlock with DML session
9.2.0.6 3605165 Hang/deadlock between sessions concurrently loading a cursor with INVALID trigger
9.2.0.6 3627263 Deadlock / hang during RAC instance startup
9.2.0.6 3646162 False deadlock (ORA-60) in a RAC environment / TM lock mode change
9.2.0.6 3717619 Deadlock/hang possible due to concurrent cursor loads referencing same INVALID trigger
9.2.0.5 2796282 False deadlock possible using shared servers
9.2.0.5 2902030 Deadlocks in RAC not logged in alert log
9.2.0.5 2918838 Undetected deadlock for dc_tablespace_quotas among two processes
9.2.0.5 2941738 SMON processes may deadlock in RAC
9.2.0.5 2982297 ORA-4020 can occur during PLSQL name resolution
9.2.0.5 2995746 Deadlock between session doing a GRANT and another session parsing an aged out cursor
9.2.0.5 3001270 Deadlock between SMON and foreground process for dc_suers
9.2.0.5 3009268 User sessions waiting for recovery of DEAD prepared TX may deadlock with SMON
9.2.0.5 3030298 OERI:2103 from concurrent 'drop tablespace including datafiles'
9.2.0.5 3080929 ORA-4021 / hang can occur due to SMON self deadlock on UNDO$ row cache lock
9.2.0.5 3093080 ALTER TABLE ENABLE TABLE LOCK can cause a deadlock
9.2.0.5 3271271 QMON can deadlock with job queue processes
9.2.0.4 1994858 False deadlock / undetected deadlock in XA
9.2.0.4 2516513 ORA-60 from concurrent PDML on same table
9.2.0.4 2554861 ORA-60 in RMAN BACKUP during RESYNC (DBMS_RCVCAT.SANITYCHECK)
9.2.0.4 2629434 Self DEADLOCK possible on HW enqueue using SMU
9.2.0.4 2670550 ORA-4020 while refreshing a MATERIALIZED VIEW
9.2.0.4 2746688 ORA-4020 possible from DDL or TRUNCATE in PLSQL
9.2.0.4 2799097 DEADLOCK possible on concurrent EXCHANGE PARTITION (DC_TABLESPACE_QUOTAS)
9.2.0.4 2864094 ORA-60 in SQL apply with multiple apply servers with rollback operations
9.2.0.4 2976372 Creating a PLSQL object intermittently fails with ORA-4021 in RAC
9.2.0.3 2136347 ORA-4020 on CREATE OR REPLACE VIEW with SELF-REFERENTIAL CONSTRAINTS
9.2.0.3 2235386 Improved diagnostics for ORA-60 deadlocks
9.2.0.3 2479110 Self deadlock (on library cache pin) revalidating INVALID PLSQL
9.2.0.3 2652409 False ORA-60 possible in RAC / OPS environments
9.2.0.3 2664217 Undetected deadlock (dc_objects V library cache lock) invalidating dependencies
9.2.0.2 2223234 Concurrent DML against a CLUSTER TABLE may deadlock
9.2.0.2 2272671 DEADLOCK possible on CREATE INDEX ONLINE (KGL lock v. TT enqueue)
9.2.0.2 2415134 SR enqueue deadlock possible
9.2.0.2 2442539 SMONs may deadlock updating COL_USAGE$ in RAC

2.1.29 Direct Path Operations

The following table lists the Direct Path Operations bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2698805 Direct path operations from SQL may hang
9.2.0.8 3865814 OERI:kghalo2 from INSERT APPEND to composite partitioned table
9.2.0.8 4197943 Dump (kpodpls) can occur using direct path load
9.2.0.8 4203324 ORA-1031 or ORA-942 from direct path loaded
9.2.0.8 4378206 Direct load of compressed table can load duplicate rows
9.2.0.8 4630627 Direct load insert loads incorrect data
9.2.0.8 4639659 SQLLDR direct load of IOT gets OERI[iot_gtab_mr_rcnt_mismatch]
9.2.0.8 4675337 OERI[klaprs_12] on sqlload in direct mode from 9.2 client to 10g server
9.2.0.7 3369324 Snapshot remains stale on complete refresh after direct load on master
9.2.0.7 3502260 OERI[12813] from concurrent insert direct load and ONLINE create index
9.2.0.7 3654015 SQLLDR direct path may incorrectly reject rows (ORA-2290) with CHECK_CONSTRAINTS
9.2.0.7 3678149 Direct SQLLOAD may dump (klctrx)
9.2.0.7 3743445 Direct path SQLLDR may load incorrect numbers for PACKED DECIMAL data
9.2.0.7 3788530 OERI[kohdtf048] with sqlldr direct load with a PLSQL function
9.2.0.7 3833809 Direct load with code conversion can fail with OERI[klaevc_01]
9.2.0.7 3866720 SQL*Loader-709 occurs during direct load on multi-CPU machine
9.2.0.7 3868753 Concurrent export / INSERT of ASSM segment can fail with ORA-1410 / ORA-8103
9.2.0.7 4085785 OERI[6191] on compressed partition direct export
9.2.0.7 4216597 ORA-1036 from OCIDirPathPrepare in OCI_UTF16 mode
9.2.0.7 4369117 OCI direct path out-of-line LOB insert slow
9.2.0.6 2322586 ORA-7445 [QERLTIDLM] using APPEND hint and INSTEAD OF triggers
9.2.0.6 2691348 ORA-600 [16049] from direct load into partitioned table with bitmap join index
9.2.0.6 2708814 Fewer rows per block than expected from direct load with SQL functions
9.2.0.6 2723819 Direct SQLLOAD may fail (OERI:6937 / OERI:kcblnb_1) with small PCTFREE
9.2.0.6 2942185 Corruption occurs on direct path load into IOT with ADDED columns
9.2.0.6 3083905 Direct load may fail with error for NULL column data
9.2.0.6 3313274 Direct path load of LOBs can cause data loss/truncation in streams
9.2.0.6 3336551 SQLLDR direct path fails using SQL strings in the control file
9.2.0.6 3461768 SQLLDR direct path may reject good rows after character to RAW conversion error
9.2.0.6 3482332 Direct path loads may fail / corrupt space information
9.2.0.6 3560900 OERI[kcbchg1_3] during direct path insert
9.2.0.6 3568433 Apply gets unsupported LCR or no-data found error for partitioned tables
9.2.0.5 2452490 SQLLDR DIRECT=TRUE SQL expression performance slower than CONVENTIONAL path
9.2.0.5 2620683 SQLLDR direct load to another users partition fails with ORA-1031
9.2.0.5 2641125 OERI:klaevcbk_2 loading data in direct path if result of SQL expression too large
9.2.0.5 2892729 PDML direct path insert not replicated to the logical standby
9.2.0.5 2902986 Clustered table direct export produces a corrupted dump exporting migrated rows
9.2.0.5 2923669 OERI[klaprs_30] / DUMP from SQLLDR direct path load
9.2.0.5 3073503 Direct path load session fails with OER:klapse_30 if first loaded row gets an ORA error
9.2.0.5 3082676 ORA-12899 from INSERT APPEND inserting varchar2 into a LONG
9.2.0.5 3083560 ORA-1410 / ORA-8103 from direct path export if concurrent DML occurs
9.2.0.5 3088916 SQLLDR direct path does not evaluate SQL strings for NULL input data
9.2.0.5 3127615 SQLLDR direct load may dump
9.2.0.5 3174298 SQLLDR direct path load may load 0 instead of NULL if length-value is NULL
9.2.0.5 3264088 Direct load may be slow due to repeated file open/close
9.2.0.4 2392885 Direct path load may fail with OERI:kcbgcur_9 / OERI:ktfduedel2
9.2.0.4 2762475 DIRECT PATH LOAD not replicated by streams / logical standby apply
9.2.0.3 2354965 False fractured block messages possible during Direct Path IO
9.2.0.3 2479354 Direct path load of column Objects give wrong results / dumps

2.1.30 Domain Indexes

The following table lists the Domain Indexes bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3219917 OERI:20083 a DOMAIN index in a rowid-to-bitmap conversion
9.2.0.8 3901321 Dump during DDL on remote table with domain index
9.2.0.8 4188472 Memory leak using DOMAIN indexes
9.2.0.8 4431195 Temporary lob leak during domain index sync operations
9.2.0.8 4499035 Dump in lnxmin() when using an ANCILLIARY operator of a domain index
9.2.0.8 4502066 Crash during rebuild of partition domain index leaves index unusable
9.2.0.8 4644425 SGA corruption on UPDATE with functional domain index
9.2.0.7 2682426 OERI:13013 from "bitmap AND" of DOMAIN index scans
9.2.0.7 2942560 In IO cost model functional domain index invocation uses bad costing
9.2.0.7 3225530 DBMS_METADATA fails to generate complete definition for a domain index
9.2.0.7 3685659 Export of DOMAIN INDEXes can write truncated CREATE INDEX information to the DMP file
9.2.0.7 3790371 Parallel domain index creation can use excessing TEMP space
9.2.0.7 3962643 Dump / corruption using user defined operators
9.2.0.6 2893444 Internal SQL in the extensible optimizer does not always use bind variables
9.2.0.6 2909346 Domain indexes can produce recursive literal SQL (affects shared pool)
9.2.0.6 3094739 ORA-29908 / ORA-12801 using PQ with ancilliary operators such as CONTAINS / SCORE
9.2.0.6 3105313 Dump[strlen] when performing a domain-index search with a UNION
9.2.0.6 3121424 OERI[qxidmgetrid:wrong typ_qeeOpt] on ALTER DB CHARACTERSET with domain index
9.2.0.6 3162494 Dump (qcsfsqcn) querying XMLType column with VARRAY and domain index
9.2.0.6 3194997 DDL against domain indexes can use lots of memory
9.2.0.6 3200136 Wrong results possible from MERGE JOIN CARTESIAN with DOMAIN INDEX
9.2.0.6 3347339 Stored outline has "NO_ACCESS" instead of "INDEX" hint for domain index access
9.2.0.6 3545539 Dump under kgmexec->kglpnp using trusted callouts / domain indexes / Oracle Text
9.2.0.6 3779927 Dump (under qxidmid) from INSERT INTO with a DOMAIN index
9.2.0.5 3124536 I XML related objects may be invalidated on applying a 9.2 Patch Set
9.2.0.5 2504348 Synonyms are not recognized in domain index functions (ORA-942)
9.2.0.5 2736734 Sub-optimal plan chosen when domain index exists
9.2.0.5 3007667 Spatial / domain index queries against partitioned table may dump in qximirew
9.2.0.5 3113248 Dump possible using DOMAIN INDEX operators on partitioned table in parallel
9.2.0.5 3155189 ODCIColInfo.TablePartition is not set during local partition scan
9.2.0.5 3175674 Poor performance of primary key Domain index on IOTs
9.2.0.4 2484969 CBO may make multiple calls to ODCIStats functions
9.2.0.4 2749361 Create DOMAIN INDEX fails on SUBTYPED OBJECT
9.2.0.3 2467216 MERGE/SPLIT partition with LOCAL DOMAIN indexes and UPDATE GLOBAL INDEXES dumps
9.2.0.3 2526334 OERI:25012 from AND EQUAL with B-Tree and DOMAIN index
9.2.0.3 2628799 Blank data from Domain Index only scan fetching PK only for IOT
9.2.0.3 2631842 DBMS_ODCI.ESTIMATE_CPU_UNIT results loose accuracy
9.2.0.3 2660592 CBO may needlessly evaluate bitmap plans for Domain indexes
9.2.0.2 2366678 + Passing parameters to CALLOUTS may dump or report ORA-600 errors
9.2.0.2 2099345 Parameters are not passed properly to ODCIStats routines for STATIC TYPE METHODS
9.2.0.2 2161360 DROP of OPERATOR corrupts dictionary - ORA-29836 on ALTER INDEXTYPE
9.2.0.2 2223449 ORA-29925 / ORA-932 from DML against table with functional DOMAIN index on ADT expression
9.2.0.2 2312728 Query against partitioned DOMAIN index dumps if there are many partitions
9.2.0.2 2498186 DEPENDENCY$ corrupted on ALTER INDEXTYPE

2.1.31 Excessive CPU Usage

The following table lists the Excessive CPU Usage bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 3610777 Excessive CPU from INDEX insert into ASSM index segment
9.2.0.8 4111602 SMON / LMD can consume 100% CPU requesting TA / US enqueue
9.2.0.8 4224765 REPLACE on a CLOB spins in kole_simple_string_match
9.2.0.8 4451759 OERI:729 using session cached cursors with DB link
9.2.0.8 4696143 Shared latch spins should not be multiplied by number of CPUs
9.2.0.8 4697189 High CPU usage for large sorts
9.2.0.8 4900129 High CPU consumption during parse for unused CHECK constraints
9.2.0.7 2785957 Streams CPU overhead for LCRs with non-final ADTs and collections
9.2.0.7 3898338 High parse time with USE_CONCAT and inlists
9.2.0.7 4098102 High CPU consumption by AQ listen
9.2.0.7 4114759 Poor performance with DBMS_OBFUSCATION_TOOLKIT.des3getkey (part 2)
9.2.0.6 3216002 HASH JOIN ANTI / SEMI can use a lot of CPU / spin
9.2.0.6 3239873 High CPU during parse of statements with many identical predicates
9.2.0.6 3281907 Export / import of a composite partitioned table can appear to spin during IMPORT
9.2.0.6 3336594 High CPU use in QMON scanning DEF$ tables needlessly
9.2.0.6 3405237 ORA-4031 / excessing SGA consumption due to large IN LIST and NOT IN list
9.2.0.6 3490914 High CPU use during lock escalation retry
9.2.0.6 3756797 High CPU may be used during parse of certain query forms
9.2.0.5 3119855 P Win: High CPU usage possible from certain XML queries
9.2.0.5 1486580 SMON inefficient when checking for failed online index builds
9.2.0.5 2740472 Shared servers burn CPU executing Java "wait()" call
9.2.0.5 2867085 Excessive PARSE CPU under expcmo / expCheckExprEquiv
9.2.0.5 3009359 Higher CPU use if SQL_TRACE=TRUE
9.2.0.5 3048661 Create bitmap index can use more CPU than needed if more memory available
9.2.0.5 3199732 Setting PGA_AGGREGATE_TARGET too low can cause excessive CPU use
9.2.0.4 2785102 Query involving many partitions (>1000) has high CPU/memory use
9.2.0.4 2834669 JDBC 9.2 thin uses more CPU (in client) than 8.1
9.2.0.4 2842026 SQL APPLY coordinator can use excessive CPU
9.2.0.4 2858886 LCK process may use excessive CPU
9.2.0.3 2647211 + Implicit cursor FOR loop memory leak / CPU hit
9.2.0.3 2533616 Materialized view refresh can use lots of CPU
9.2.0.3 2580238 Reduce CPU usage of multiple DBW processes with RAC
9.2.0.3 2610596 Huge CPU usage from RMAN server when TAPE not mounted with BACKUP_TAPE_IO_SLAVE=TRUE

2.1.32 Export/Import

The following table lists the Export/Import bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2284163 Import may dump with indexfile option
9.2.0.8 2539145 Exempt access policy privilege not recognized by the export utility (false EXP-79)
9.2.0.8 2686629 IMP-58 / ORA-31000 during import of XML schema with maintainDOM=false
9.2.0.8 2742598 Object types with circular references are not exported if not used in table
9.2.0.8 3447032 DBMS_STATS.SET_COLUMN_STATS can be slow (affects IMPORT)
9.2.0.8 3448802 Exp / Imp / view problems if LOB tablespace blocksize different to table blocksize
9.2.0.8 3518579 Table mode export does not export parent type
9.2.0.8 3983923 Export of a partition with a nested table column exports all nested table rows
9.2.0.8 4046842 Table level export/import can produce corrupt TYPE metadata
9.2.0.8 4116981 Import may dump when importing triggers
9.2.0.8 4347949 ORA-1031 importing JAVA CLASS objects owned by SYS
9.2.0.8 4354488 Exp/imp can change the "logging" attribute of a subpartitioned table
9.2.0.8 4559546 Cannot used exp/imp of MVIEW with XMLTYPE column
9.2.0.8 4573912 ORA-24021 in DBMS_AQ_IMPORT_INTERNAL.AQ_DEFN_UPDATE on 9i import of queue
9.2.0.8 4711857 Exp/Imp of table with LONG swaps COMMENTS metadata
9.2.0.8 4898699 Reverse key index with system generated name is not exported
9.2.0.8 5031489 ORA-1455 during full database export
9.2.0.7 2375764 Export fails with ORA-1455 if leaf_blocks or distinct_keys >= 2^31
9.2.0.7 2549858 ORA-904 during import of XML table with VARRAY
9.2.0.7 2549870 Import errors (ORA-904) importing XML table with "STORE AS CLOB" clause
9.2.0.7 2820067 ORA-1455 during export if some statistics are over 2^31
9.2.0.7 3467622 ORA-4063 during import of RLS policy on view
9.2.0.7 3575797 XMLSchemas and types are not exported in table and tablespace mode export
9.2.0.7 3591564 ORA-1756 importing functional index with CHR(0) in its expression
9.2.0.7 3626425 Export of schema based XMLType may dump
9.2.0.7 3685659 Export of DOMAIN INDEXes can write truncated CREATE INDEX information to the DMP file
9.2.0.7 3738705 Incorrect CREATE TABLE SQL written to DMP file for "not substitutable at all levels"
9.2.0.7 3798351 Importing a pre-existing table may DROP the table on an error
9.2.0.7 3831513 Import to different character set can fail (PLS-103) if PLSQL contains a NEWLINE in quotes
9.2.0.7 3868753 Concurrent export / INSERT of ASSM segment can fail with ORA-1410 / ORA-8103
9.2.0.7 3946544 EXP-62 if the header of a wrapped TYPE contains a comment
9.2.0.7 4015652 Nested Table export fails with ORA-1007
9.2.0.7 4016802 Incorrect export produced for transport of composite partitioned table
9.2.0.7 4018783 OERI [12333] on import of table with a LONG column
9.2.0.7 4047608 Export/import can loose the LOGGING attribute of LOB columns
9.2.0.7 4085785 OERI[6191] on compressed partition direct export
9.2.0.7 4089843 Export of table with OLS policy does not export "label function" properly
9.2.0.7 4154125 Export writes bad SQL to DMP file for XMLTYPE tables with DEFAULT clauses
9.2.0.6 2270510 IMP-58 / ORA-22337 importing evolved type object table
9.2.0.6 2660473 Export of a renamed table leaves the trigger pointing to the old tablename
9.2.0.6 2669061 ORA-1007 exporting table with VARRAY
9.2.0.6 2834541 IMP-93 on import when using the TOUSER parameter
9.2.0.6 3109964 Export 8i / import AQ queue can give ORA-24033 when enqueueing a message
9.2.0.6 3154636 Export may dump exporting triggers
9.2.0.6 3159124 EXP-68 even though locally managed tablespaces are not offline
9.2.0.6 3276952 Export / import of nested table from dictionary to locally managed tablespace fails
9.2.0.6 3281062 Export of xmlschema based table is slow
9.2.0.6 3281907 Export / import of a composite partitioned table can appear to spin during IMPORT
9.2.0.6 3286346 Rebuild partitioned index and exp/imp of statistics causes inconsistent stats
9.2.0.6 3291851 EXP-3 exporting LOB from 9205 or higher DB with <9205 export
9.2.0.6 3322366 Imported outlines are not used
9.2.0.6 3324661 Full export/import fails with IMP-17 / ORA-2494
9.2.0.6 3361288 Export of XMLSCHEMA may fail with ORA-24324 in UTF8
9.2.0.6 3400967 IMP-17 / ORA-6550 importing a wrapped password verification function
9.2.0.6 3579567 Corrupt export exporting a compressed table with direct=y (IMP-9)
9.2.0.5 2355645 OCI-21500 [kopuigpfx1] after constraint violation using IMPORT with XMLTYPE
9.2.0.5 2598438 ORA-1722 from DBMS_AQ_SYS_IMP_INTERNAL during import of queue table/s
9.2.0.5 2619341 Export may contain invalid SQL for CREATE SYNONYM in FULL export
9.2.0.5 2666174 Export in direct path can product a corrupt export file if ORA-1555 occurs
9.2.0.5 2792496 Import may dump importing a trigger with "--" comment before the trigger name
9.2.0.5 2902986 Clustered table direct export produces a corrupted dump exporting migrated rows
9.2.0.5 2919120 Full export may fail with ORA-1422 if 2 triggers have same name
9.2.0.5 3031024 Export of object types and many subtypes produces bad export file (OCI-22303 on import)
9.2.0.5 3041342 Bad DDL in export file exporting a table which is not substitutable at all levels
9.2.0.5 3051801 ORA-6502 from EXPORT if CDC returns a long string
9.2.0.5 3083560 ORA-1410 / ORA-8103 from direct path export if concurrent DML occurs
9.2.0.5 3138734 EXP-56 ORA-31600 exporting DB with > 10000 users with Data Mining option
9.2.0.5 3150037 Export may produce wrong SQL for CREATE TABLE xxx OF typename
9.2.0.5 3230116 Direct export of a compressed table fails with OERI[6193]
9.2.0.5 3291851 EXP-3 exporting LOB from 9205 or higher DB with <9205 export
9.2.0.4 2746788 + Export does not error on DISK FULL conditions (IMP-9 on import)
9.2.0.4 809293 ORA-4071 during IMPORT of trigger with SPACES in definition
9.2.0.4 2519640 User level export slow (compared to DBA export)
9.2.0.4 2631450 IMP-17 / ORA-6550 possible on exp/imp of large rule sets
9.2.0.4 2672970 EXP-10 if username contains ".", ":" or "%"
9.2.0.4 2685696 ORA-1422 from Export in package XDB.DBMS_XDBUTIL_INT
9.2.0.4 2740454 Export of statistics may write bad details to the .DMP file
9.2.0.4 2750878 IMPORT does not work for Schema based XMLTable in multibyte
9.2.0.4 2801371 IMP-58 / ORA-19007 importing XMLType table with XML schema
9.2.0.4 2809130 Queue import can corrupt dictionary metadata if queue pre-exists
9.2.0.4 2854856 ORA-911 can occur importing a trigger in a mixed case SCHEMA name
9.2.0.4 2862818 Bad export of NESTED table in LOCALLY managed tablespace - ORA-25150 / ORA-942 on import
9.2.0.4 2881018 EXP/IMP of Queues after DB upgrade to 9.2 fails
9.2.0.4 2882923 ORA-1031 importing Queue table
9.2.0.4 2900891 8i Export from 9.2 DB fails with EXP-8 ORA-904
9.2.0.3 2598387 * Export / OCI clients using prefetch may see corrupt data. This bug is alerted in Note:223399.1
9.2.0.3 2381172 + IMPORT fails / corrupts the AQ dictionary with duplicate QUEUE_TABLE names
9.2.0.3 2261722 8i export of 9i database dump (in koputilassert) with SUBTYPE / NOT FINAL type
9.2.0.3 2435257 IMP-3 / ORA-1031 in SYS.DBMS.DDL if IMP_FULL_DATABASE granted via a ROLE
9.2.0.3 2448243 Full export from non DBA user may fail with ORA-1031 in SYS.LT_EXPORT_PKG
9.2.0.3 2461455 ORA-7445 [qcdlgtd] or ORA-942 from IMPORT FROMUSER / TOUSER
9.2.0.3 2488590 EXP-8 ORA-3113 exporting large CREATE OPERATOR statement
9.2.0.3 2508813 ORA-16000 exporting from READ ONLY database
9.2.0.3 2598124 EXP-8 / ORA-1422 if queue and queue table have same name
9.2.0.3 2599613 IMP-60 possible when object already exists in database
9.2.0.3 2629652 PLS-302 'EXPORT_RULE_SET' must be declared from EXPORT
9.2.0.3 2687401 XDBSCHEMAs may not be imported to correct schema
9.2.0.2 2311919 + FULL export with datafile > 1024M produces WRONG size datafiles in .DMP file
9.2.0.2 2179567 Updatable snapshots do not work after 8.0 export -> 8i/9i import
9.2.0.2 2249786 IMP-17 / ORA-24150 possible importing user RULE SET
9.2.0.2 2249845 Export does not export SUPPLEMENTAL LOG syntax
9.2.0.2 2300104 CREATE VIEW OF TYPE .. UNDER .. does not export the UNDER clause
9.2.0.2 2308033 OERI:6191 / OERI:6193 possible on DIRECT mode EXPORT of long row with >=8k DB_BLOCK_SIZE
9.2.0.2 2401529 IMP-17/ORA-1031 DBMS_RULE_EXIMP importing 9.0 export file into 9.2
9.2.0.2 2488515 EXP-8/ORA-911 on DBMS_RULE_EXP_RL_INTERNAL if usernames have double quotes

2.1.33 External Tables

The following table lists the External Tables bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2461069 Zoned fields are not working when NULLIF is used in external table
9.2.0.8 4483831 Bad date data in external table can give wrong results
9.2.0.7 3430105 Parallel full scan of an external table may "SKIP" more rows than defined
9.2.0.7 4007026 Accessing an external table can leak file descriptors
9.2.0.6 3250195 KUP-4050 / memory leak from consecutive SELECTs against external table
9.2.0.6 3357740 Wrong results from external table in subquery
9.2.0.6 3748283 Small PGA memory leak in kpodscn for long running PLSQL against external tables
9.2.0.5 2453893 Memory corruption SELECTing from an EXTERNAL TABLE with many discarded rows
9.2.0.5 3103876 External tables access can cause excessive rowcache activity
9.2.0.5 3134348 External table memory leak in "alloc environm" subheap
9.2.0.5 3177686 Incorrect column names in error message when using external tables
9.2.0.4 2710266 ORA-7445 [KKXMIXCX] with EXTERNAL TABLE in a subquery
9.2.0.4 2862067 ORA-29913 from ZONED DATA TYPE in EXTERNAL TABLE
9.2.0.4 2867563 OERI:KSMFRFG2 / memory corruption selecting from an EXTERNAL TABLE
9.2.0.3 2662576 EXTERNAL TABLE select may fail with OERI:[KPXSDPINIT_02]
9.2.0.2 1788921 ENH: Add OCI_ATT_IS_EXTERNAL attribute to show table is EXTERNAL
9.2.0.2 2179558 ORA-7445[KOTGTSCH] possible selecting from external table
9.2.0.2 2214266 Multibyte EXTERNAL TABLE with >1 file may return wrong results
9.2.0.2 2245711 TERMINATED BY " " with ENCLOSED BY may incorrectly reject rows
9.2.0.2 2245909 SQLLoad with EXTERNAL_TABLE does not find DIRECTORY objects correctly
9.2.0.2 2290323 EXTERNAL TABLE parameters should disallow symbollic links

2.1.34 Feature Unusable

The following table lists the Feature Unusable bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.6 1488818 ALTER TABLE MOVE on a table of nested table fails with ORA-932
9.2.0.6 3224506 XA client using TAF may not failover correctly
9.2.0.6 3741539 Logical standby may apply DML from a DDL more than once
9.2.0.5 2940957 PRE_PAGE_SGA does not work on some platforms (eg Windows)
9.2.0.5 3051758 SAMPLE keyword in SQL gives same result-set if executed quickly in succession
9.2.0.5 3272092 Diagnostic heap checking Event 10501 does not work on some heaps
9.2.0.4 2945011 VLM (USE_INDIRECT_DATA_BUFFERS=TRUE) does not work on Standard Edition Oracle

2.1.35 Flashback

The following table lists the Flashback bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 4350027 Session level flashback not enabled within logon triggers
9.2.0.7 4252656 Dump in ktfpsnps during flashback operatios

2.1.36 Function Based Index (Including DESC Indexes)

The following table lists the Function Based Index (Including DESC Indexes) bugs addressed in this patch set:

Fixed in Release Bug Number Description
9.2.0.8 2212987 Dictionary corruption can occur as function index allowed when it should not
9.2.0.8 2692199 ORA-12805 from PQ MERGE with update clause with a functional index
9.2.0.8 3975758 INLIST ITERATOR not used if column part of DESC index
9.2.0.8 4096288 Dump (nsoexc) parsing ANSI outer join with functional indexes
9.2.0.8 4198156 Index-only retrieval not chosen with IOT and function based index
9.2.0.8 4246090 IOT corruption from buffered INSERT with function based index (ORA-8102)
9.2.0.8 4486132 Query using function based index gives wrong results
9.2.0.8 4767699 Spin in qcsjFindFroInQbc for query with join and functional index
9.2.0.8 4869429 OERI[qkagby0.4] from PQ with functional index aggregate