Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import Error

Re: Import Error

From: David Weaver <dweaver_at_conraildirect.com>
Date: Wed, 31 Mar 1999 15:18:50 GMT
Message-ID: <37023cb2.140072072@news.erols.com>


On Wed, 31 Mar 1999 01:02:22 GMT, Denny Koovakattu <denny_vk_at_my-dejanews.com> wrote:

Denny,

I didnt hear about that one. I'll give it a try.

Thanks

Dave
>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 Wed Mar 31 1999 - 09:18:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US