Re: Import Problems

On 6 Apr 1995, Carol KIlner wrote:

> I have an export file from an Oracle box running version 7.1.3.
> I am trying to run the import on an Oracle box running version
> 7.0.13. The process dies when it tries to import the first stored=20
> procedure.

>=20

>=20

>=20

=09I can't find documentation to prove it, but since the
=09usual format of the statement is 'CREATE PROCEDURE ...'
=09and the export made it 'CREATE FORMAT71 PROCEDURE ...',
=09my gut feeling is that there is a difference in the way
=097.0 and 7.1 deal with procedures, and the export file
=09uses this extra word to tell import what to do.  Since=20
=09the 7.0 import knows nothing about 7.1 format (or whatever
=09that keyword means), I have to agree that you may need
=09at least the exp/imp from 7.1 to read the file.=20

=09Good Luck !

=09helena

--
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>
<: Helena Whitaker, Database Administrator      helena_at_creighton.edu :>
<: Creighton University               (0800-1630 CT)   (402)280-2311 :>
<: Old Gym - 2500 California Plaza                fax  (402)280-2573 :>
<: Admin Computing-Fin Sys Spt          Platform: HP-UX 9.0.4 (unix) :>
<: Omaha, NE 68178-0046              HP 9000/887 (aka H50), 842, 806 :>
<:                            Oracle 6.0.36.7.1/Banner Finance 2.0.3 :>
<:                            Oracle 7.1.3/DeLair Patient Accounting :>
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>