Bug No. 3064929
Filed 23-JUL-2003
Updated 19-AUG-2003
Product Oracle Server - Enterprise Edition V7
Product Version 9.2.0.3.0
Platform Generic
Platform Version No Data
Database Version 9.2.0.3.0
Affects Platforms Generic
Severity Severe Loss of Service
Status Closed, not feasible to fix
Base Bug N/A
Fixed in Product Version No Data
Problem statement:
ORA-2332 CREATING AN INDEX ON A REF COLUMN IN 9.2.0.3
*** 07/23/03 06:48 am ***
TAR:
----
3262208.999
.
PROBLEM:
--------
ORA-2332 error trying to create an index on a REF COLUMN in 9.2.0
This same operation works succesfully in 9.0.1
DIAGNOSTIC ANALYSIS:
--------------------
Reproduced in 9.2.0
The index is created succesfully in 9.0.1.4
WORKAROUND:
-----------
None
RELATED BUGS:
-------------
BUG 2744943
REPRODUCIBILITY:
----------------
Every time in 9.2.0.x
It works succesfully in 9.0.1.
TEST CASE:
----------
drop table tab_obj_Sections;
drop table tab_obj_Departments;
drop type typ_obj_Section;
drop type typ_obj_Department;
.
CREATE TYPE typ_obj_Department is object
(
Code VARCHAR2(10),
Nom VARCHAR2(50)
) NOT FINAL;
/
CREATE TABLE tab_obj_Departments OF typ_obj_Department
(
CONSTRAINT pk_Departments PRIMARY KEY(Code)
) OIDINDEX oid_Departments
/
CREATE TYPE typ_obj_Section is object
(
Code VARCHAR2(10),
Nom VARCHAR2(50),
RefDepartment REF typ_obj_Department
) NOT FINAL;
/
CREATE TABLE tab_obj_Sections OF typ_obj_Section
(
CONSTRAINT fk_Sections_Dept FOREIGN KEY(RefDepartment) REFERENCES
tab_obj_Departments
) OIDINDEX oid_Sections
/
CREATE UNIQUE INDEX pk_Sections ON tab_obj_Sections (RefDepartment.Code)
/
This last statement reports this error in 9.2.0.1
ORA-2332: cannot create index on attributes of this column
but works fine in 9.0.1.4
STACK TRACE:
------------
NA
.
SUPPORTING INFORMATION:
-----------------------
24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------
DIAL-IN INFORMATION:
--------------------
IMPACT DATE:
------------
After upgrade from 9.0.1 to 9.2 customer is not able to create this kind of
indexes, so this problem is affecting seriously their environment.
.
*** 07/23/03 08:43 am *** (CHG: Sta->16 Asg->NEW OWNER)
*** 07/24/03 01:55 am *** (CHG: Sta->11 Asg->NEW OWNER)
*** 07/24/03 01:55 am ***
*** 07/24/03 10:55 am *** (CHG: Asg->NEW OWNER)
*** 07/24/03 10:55 am ***
*** 08/01/03 06:12 am *** (CHG: Asg->NEW OWNER)
*** 08/06/03 11:03 pm ***
*** 08/06/03 11:04 pm *** (CHG: Sta->44)
*** 08/19/03 03:12 am ***
*** 08/19/03 03:14 am *** (CHG: Sta->84)
*** 08/19/03 03:14 am ***
The pk-based reference have packed representation. Thus we don't have the cloumn information for each attribute. As per base, this behavior is okay as we.
are trying to create a index on the type attrbute (RefDepartment.Code).So ora-2332 is the right error message. The fact that it used to work in 9014 was an undesirable behavior.
To resolve this bug, enhancement is required in the product. Closing this
bug as not feasible to fix. File a seperate enhancement request.
Raised Enhancement request for this BUG against Bug number 3104504.
Partager