Things got a little interesting elsewhere, so I didn't have any time to follow up on this until now.
It looks like I got it to work, but I'm not confident enough in the process to subject our production database to it.
We will probably take the easy (?) way out by cold-copying the .dbf files and performing a version migration. DBA sez
Looks like it's just a matter of running a few scripts. I say "looks like" because the various docs I've found on M-L are somewhat vague about DBs w/ interMedia.
:->
How I probably got a working context by migrating:
- exp from the 8.1.6 database
- copy files, imp into the 8.1.7.4 database
- run the same imp a second time (seems to be some ordering/recursion problem in the creation of various pl/sql procs)
- drop index sws_ctx_index force
- Run @load-site-wide-search
- Still broken, so @recreate-site-wide-search
Success!
The errors between steps 5 and 6 were:
old 3: ctx_ddl.set_attribute('sws_user_datastore', 'procedure', 'sws_user_proc_&1');
new 3: ctx_ddl.set_attribute('sws_user_datastore', 'procedure', 'sws_user_proc_staging');
begin
*
ERROR at line 1:
ORA-20000: interMedia Text error:
DRG-10701: preference STAGING.SWS_USER_DATASTORE already exists
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.CTX_DDL", line 55
ORA-06512: at line 2
create index sws_ctx_index on site_wide_index (datastore)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
DRG-10707: a value is required for attribute PROCEDURE of preference
sws_user_datastore
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
ORA-06512: at line 1
alter index sws_ctx_index rebuild parameters('sync')
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
DRG-10561: index SWS_CTX_INDEX is not valid for requested operation
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 214
ORA-06512: at line 1
