The best solution I have been able to come up with is, ,

upgrade the machine to 2.1
then for each database in turn,
extract the ddl into a script, remove the unwanted udf definitions
build a new database from the script
datapump from old to new
rename database files

any comments?



2008/9/1 Nick Upson <nick.upson@...>

> I need to upgrade several databases (1.5 & 2.0) to 2.1 in the near
> future. I was planning on doing the standard "backup with old version,
> upgrade, restore with new" method but realised that means the old udf's will
> be carried forward whereas I want to use the new built-in version.
>
> I'd rather not have to do each one manually, any suggestions for a
> scripted method
>

[Non-text portions of this message have been removed]