Re: Import Error

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
Received on Tue Mar 30 1999 - 15:05:59 CST