Re: IMP Please Explanation

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 17 May 2005 10:50:00 -0700
Message-ID: <1116352200.305525.267420@g14g2000cwa.googlegroups.com>

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 Received on Tue May 17 2005 - 12:50:00 CDT