Re: Import Error

I am not sure about this, but I remember reading about a bug in direct mode export where rows have nulls at the end. Can you try without using direct mode ?

Denny

In article <370139c5.73782774_at_news.erols.com>,   dweaver_at_conraildirect.com wrote:
> On Tue, 30 Mar 1999 19:03:56 GMT, Denny Koovakattu
> <denny_vk_at_my-dejanews.com> wrote:
>
> Denny,
>
> Both databases are the same. To avoid any problems, I drop all of the
> users except for sys, so the databse is essentially empty. The table
> structure may be a little different but I dont think thats a problem
> since its importing both the structure and data. I have used the same
> procedure about a dozen times and this time it just wont import. Its
> really annoying. I am using the direct mode(?) export I think, right
> from the command line in DOS.
>
> thanks for the help
>
> Dave
>
> >Dave,
> >
> > Are both the production and test database versions the same ? Are you using
> >direct mode export ?
> >
> >Denny
> >
> >In article <3701ecba.54059373_at_news.erols.com>,
> > dweaver_at_conraildirect.com wrote:
> >> On Mon, 29 Mar 1999 21:23:23 GMT, Denny Koovakattu
> >> <denny_vk_at_my-dejanews.com> wrote:
> >>
> >> Thanks for the response.
> >>
> >> I'm not importing thru FTP. I'm doing it using the exp73 function from
> >> DOS and inputting the paramaters.
> >>
> >> Thanks
> >>
> >> Dave
> >>
> >> >If you ftp'ed your export dump to your test machine, did you set the mode
to
> >> >binary ?
> >> >
> >> >Denny
> >> >In article <3700ccd6.243932436_at_news.erols.com>,
> >> > dweaver_at_conraildirect.com wrote:
> >> >> Hello,
> >> >>
> >> >> I have done a export of my entire database(861MB) and am trying to
> >> >> import it into my test environment. However I am running up an error
> >> >>
> >> >> IMP -00009 abnormal end of export file and
> >> >>
> >> >> IMP - 00021 operating system error - error code (dec22, hex 0x16).
> >> >>
> >> >> Does anyone have any experience with any of these 2 errors?
> >> >>
> >> >> I am running 7.3.2.3.7
> >> >>
> >> >> Thanks In advance.
> >> >>
> >> >> David Weaver
> >> >>
> >> >
> >> >-----------== Posted via Deja News, The Discussion Network ==----------
> >> >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >>
> >>
> >
> >-----------== Posted via Deja News, The Discussion Network ==----------
> >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 30 1999 - 19:02:22 CST