| tunning wizard oracle 9i can not collect schema oracle 7.3.4 [message #171504] |
Wed, 10 May 2006 05:01 |
rivadarwito
Messages: 1
Registered: May 2006
|
Junior Member |
|
|
hi guys, please help me to solve this problem :
i tried to execute oracle index tuning wizard from oracle 9i to a target database in oracle 7.3.4. the process was stopped when the wizard try to collect tables and view from target database as you see as follows :
XP-21016: A database error has occurred: /* OracleOEM */
SELECT
IU."NAME",
IO."NAME"
FROM SYS.USER$ IU, SYS.OBJ$ IO, SYS.USER$ U, SYS.OBJ$ O, SYS.IND$ I
WHERE
O."NAME" = :2
AND U."NAME" = :1
AND I.BO# = O.OBJ#
AND O.OWNER# = U.USER#
AND IU.USER# = IO.OWNER#
AND IO.OBJ# = I.OBJ#
AND NOT EXISTS
(
SELECT
'X'
FROM SYS.CON$ OC, SYS.CON$ RC, SYS.OBJ$ O2, SYS.CDEF$ C
WHERE OC."NAME" = IO."NAME"
AND OC.OWNER# = U.USER#
AND OC.CON# = C.CON#
AND C.OBJ# = O2.OBJ#
AND C.TYPE# != 
ORA-00904: invalid column name
then i checked in target database there is different column name TYPE# in table SYS.CDEF$ in ORACLE 9i and TYPE in table SYS.CDEF$
in ORACLE 7.3.4 (target database)
what should i do ?
TIA
rivadarwito
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
