optimizer function based indexes

2001-10-02 Thread Josef Huber
hello i've update my database from 8.1.7 release 3 to 9iand now following statement don't use my optimizer hint in 9i (in 8i itworks)upper_artikel_kurztext_idx is an function based indexselect /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikelwhere upper(kurztext) LIKE

upgrade to 9i

2001-09-25 Thread Josef Huber
hello i've tried a test upgrade of my database 8i release 3 windows 2000 server to 9i i've run all scripts from the docs and know there are 73 sys packages invalid after installutlrp.sql have i executed have anybody some ideas ? thanx

Upgrade Oracle from 8.1.7 Release 3 to 9.0.1

2001-09-19 Thread Josef Huber
Hello i want to upgrade my database from 8.1.7 to 9.0.1 system: windows 2000 server sp1 2 oracle database instances i've installed the oracle 9i software on the server (seperate home ..) now i want to the update via the oracle data migration assistant i specify my password and my correct