Re: IMP Please Explanation

Rauf Sarwar wrote:
> stephen.how..._at_us.pwcglobal.com wrote:
> > I'm, not sure how it couldn't be an export file if Oracle provided
> that
> > error message...
> >
> > U:\>dir *txt
> > Volume in drive U is Data
> > Volume Serial Number is 844B-5019
> >
> > Directory of U:\
> >
> > 12/14/2004 01:48p 2,434 oracle_mem_2004121415.txt
> > 01/18/2005 04:58p 5,245 oracle_mem_2005011815.txt
> > 02/25/2005 03:44p 7,784 oracle_mem_2005022514.txt
> > ....
> > 04/09/2005 09:12a 83 rman.txt
> > 17 File(s) 1,319,041 bytes
> > 0 Dir(s) 34,216,611,840 bytes free
> >
> > U:\>imp file=rman.txt
> >
> > Import: Release 9.2.0.6.0 - Production on Tue May 17 12:33:37 2005
> >
> > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> >
> > Username: scott
> > Password:
> >
> > Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 -
> > Production
> > With the Partitioning, OLAP and Oracle Data Mining options
> > JServer Release 9.2.0.6.0 - Production
> >
> > IMP-00009: abnormal end of export file
> > IMP-00000: Import terminated unsuccessfully
> >
> > U:\>
>
> You sure that is the right dump file created by exp utility? It's
only
> 83 bytes in size. Plus the name looks like it's created by RMAN or is
> it just a coincidence.
>
> The IMP-00009 error message is typically thrown if the dump file is
> either not created by exp utility OR is corrupt.
>
> Regards
> /Rauf

Rauf,

LOL, no I was trying to show (evidently not very well ;)) that Oracle would throw an error if it *wasn't* a file created by export. You gave me a good laugh, though.

Regards,

Steve Received on Tue May 17 2005 - 16:40:46 CDT