Re: Oracle 8.1 NT-> Linux

What is your structure (schema structure) on the Linux ? Is it the same as the NT box ? If everything is similar then the problem should be physical and you might want to use more parameters in the parfile. Increasing the buffer might be a start. Let me know what happens.

                                Tapan

Derek J Becker wrote:
>
> OK, the deal is taht I have an oracle database in 8.1.5 that people are
> using but for misc. reasons now has to be moved over to a Linux/Red Hat
> platform. Fine.
>
> The NT export goes wonderfully:
> exp system/******** file=dumpfile.dmp owner=ssc
>
> Then I ftp it over to the Linux platform (yes in binary mode). The byte
> count for both copies of the dumpfile are identical.
>
> I go to import on the Linux machine:
> imp system/******* file=dumpfile.dmp fromuser=ssc touser=ssc
>
> and then I get about 30 or so IMP-00008 "unrecognized statement in the
> export file " errors
> a IMP-00009 "abnormal end of export file" error
> and an IMP-00034 "warning: from user 'ssc' not found in export file"
>
> Now I've double checked to make sure that the user ssc exits in both
> databases, and I've tried importing with full=y but I still get the IMP 8 &
> 9 errors.
>
> I am not a DBA by training, so I'm almost certainly doing somethign stupid,
> but for the life of me I can't figure out what!
>
> Thanks in advance
>
> Derek
Received on Thu Jul 29 1999 - 16:38:20 CDT