Re: Package ORDSYS.ORDWEBUTL in 10.1.0.4
Date: Tue, 06 Jan 2009 09:05:43 +0000
thank you for your reply.
I'm sorry for being unclear in my post- I didn't perform a full export/import which you implied, it was only required to move 2 schemas to the new database which I did using the schemas= parameter.
The "shell" database into which I imported was a 10.1.0.4 with InterMedia (and some other required options) installed.
In the meantime I found Note 224952.1 on Metalink, it explains why the package is not available in 9i later. Should anyone google for this, the ORDWEBUTL package was part of the 8i InterMedia Web Agent/Clipboard which has not been ported to 9i.
Goulet, Richard wrote:
> Well to start with according to Metalink Doc Id 228482.1 ORDSYS
> does not get included in a full export/import. Second did you install
> Intermedia in the target database?? If not maybe Metalink Doc Id
> 220018.1 would help.
> Dick Goulet
> Senior Oracle DBA
> PAREXEL International
> information transmitted in this communication is intended only for the
> person or entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this information
> by persons or entities other than the intended recipient is prohibited.
> If you received this in error, please destroy any copies, contact the
> sender and delete the material from any computer.
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Martin Bach
> Sent: Monday, January 05, 2009 10:47 AM
> To: oracle-l_at_freelists.org
> Subject: Package ORDSYS.ORDWEBUTL in 10.1.0.4
> Dear list members,
> I have recently migrated a database from 10.1.0.4 SPARC to 10.1.0.4 on
> On my end, the data went in fine (I can only recommend impdp and a low
> latency/high throughput network_link :), but some code doesn't compile
> because it references ORDSYS.ORDWEBUTL.
> This puzzles me a bit - I could of course use dbms_metadata.get_ddl to
> get the package and all the tables it references from the source
> database but I was startled that I couldn't find any reference to it on
> metalink or tahiti.oracle.com.
> I found reference to the package in Oracle 8.1.5 and it's supposedly in
> _at_$ORACLE_HOME/ord/web/admin/ordwebutl.sql. Unfortunately, this files
> neither exists on my system, nor the source.
> Can anyone shed some light on the history of that package? My best guess
> is that it's a legacy from 8i which has always been migrated up to 10.1.
> * it wasn't my decision not to migrate to 10.2.0.4 :)