Re: Package ORDSYS.ORDWEBUTL in 10.1.0.4
- From: Martin Bach <development@xxxxxxxxxxxxxxxxx>
- To: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- Date: Tue, 06 Jan 2009 09:05:43 +0000
Hi Richard,
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.
Regards,
Martin
Goulet, Richard wrote:
Martin,
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
978.313.3426
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martin Bach
Sent: Monday, January 05, 2009 10:47 AM
To: oracle-l@xxxxxxxxxxxxx
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
Linux*.
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
@$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.
Thanks!
Martin
* it wasn't my decision not to migrate to 10.2.0.4 :)
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
