Re: importing from oracle 7 to 8 error
Date: Thu, 15 Nov 2001 17:00:00 +0530
Message-ID: <9t0927$nih$1_at_news.mch.sbs.de>
Hi,
Are u importing tables with date format.If so u have to convert them to
Oracle 8 date format using the To_date function.Also what were the
parameters that u had passed while exporting.Did u specify Ignore=y.
Can u be more specific on whether u r exp. whole DB or some tables.
Regards,
Balaji.
"isterin" <isterin_at_hotmail.com> wrote in message
news:db67a7f3.0111141513.1926ffa8_at_posting.google.com...
> Hello.
>
> We have 2 versions of Oracle installed 7.3.4 and 8.1.6.0.0.
>
> I am using the 7.3 version's export to exp the file in default
> US7ASCII and then the 8.1 version's imp to import the file. I am
> getting this error message (below) and I can't figure out what it is
> doing. I know that message IMP-00067 refers to encoding, though both
> import and export are using the default of US7ASCII, I even tried
> specifying for both, same thing happens. I hope someone can give some
> advice. Thanks.
>
> Ilya
>
>
> Error message:
>
> IMP-00067: Message 67 not found; product=RDBMS; facility=IMP
>
> IMP-00021: operating system error - error code (dec 2, hex 0x2)
> IMP-00000: Import terminated unsuccessfully
Received on Thu Nov 15 2001 - 12:30:00 CET