Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

migration to 9i

6709Jan 30 2002
hi
I am Upgrading from 8.1.7.2 to 9.0.1.2 I am having few problems... here are error messages. Does any one encountered this ?

Ran c81Xu90X.sql ( $ORACLE_HOME/md/admin ) getting following
errors..
..
add sdo_relate(mdsys.sdo_geometry, mdsys.sdo_geometry, varchar2) rewrite JOIN,
*
ERROR at line 4:
ORA-04045: errors during recompilation/revalidation of MDSYS.SDO_RELATE
ORA-06552: PL/SQL: Declaration ignored
ORA-06553: PLS-500: invalid operator binding
drop sdo_dummy(mdsys.sdo_geometry, mdsys.sdo_geometry, varchar2)
*
ERROR at line 2:
ORA-29843: indextype should support atleast one operator

rg
naren
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2002
Added on Jan 30 2002
1 comment
304 views