Re: Export for Upgrade

"Jonathan Bliss" <bliss_jonathan_at_hotmail.com> wrote in message news:6yjo9.503$Eb6.59991_at_newsfep1-gui.server.ntli.net...

> Thanks for this, I'll give it a go. As for the import, if the 8.1.7
8import
> won't read it, I don't see why I cannot add my windows box to my tnsnames
on
> the Unix box and run the 7.2 import from the Unix box.
>
> Jonathan
>
>

You'd still need to be able to access the export file from the unix box so you'd either need to store the file locally, or use the same technique (i.e. a named pipe) to pipe the data directly from the exp utility into the imp utility. Also if you do use the 7.2 import utility against an 8i database you are probably going to run into problems with imp not recognizing the catalog objects it needs. If it complains run the 7.2 catexp.sql script against the 8i database and try the import again. When finished be sure to rerun the 8i catexp script against it to put the catalog back the way it was. Received on Tue Oct 08 2002 - 08:11:46 CDT