Exp-00002 
Author Message
 Exp-00002
Hi,

I am encountering exp-00002 during an full export. The export process
was accidentially overlaying an existing .dmp file which I need. From
the log file, it recorded that the error terminated the process after
it exported some of the user tables.

Now, the questions I have are whether that .dmp file got written over
by the 2nd export process? Or did it get written over half way? Can I
still use it for an import? And is there anyway to fix the .dmp file
if it got written half way?

Thanks in advance.



Sun, 23 May 2004 09:53:40 GMT
 Exp-00002

Quote:

> Hi,

> I am encountering exp-00002 during an full export. The export process
> was accidentially overlaying an existing .dmp file which I need. From
> the log file, it recorded that the error terminated the process after
> it exported some of the user tables.

> Now, the questions I have are whether that .dmp file got written over
> by the 2nd export process? Or did it get written over half way? Can I
> still use it for an import? And is there anyway to fix the .dmp file
> if it got written half way?

> Thanks in advance.

Your first file is hosed.
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.


Sun, 23 May 2004 11:32:59 GMT
 Exp-00002

Quote:


> > Hi,

> > I am encountering exp-00002 during an full export. The export process
> > was accidentially overlaying an existing .dmp file which I need. From
> > the log file, it recorded that the error terminated the process after
> > it exported some of the user tables.

> > Now, the questions I have are whether that .dmp file got written over
> > by the 2nd export process? Or did it get written over half way? Can I
> > still use it for an import? And is there anyway to fix the .dmp file
> > if it got written half way?

> > Thanks in advance.
>  Your first file is hosed.

So, actually is my .dmp file got written over half way because I still
see my full size .dmp file around? And is there any way to salvage the
file with this full size file?


Mon, 24 May 2004 03:21:00 GMT
 Exp-00002

Quote:



> > > Hi,

> > > I am encountering exp-00002 during an full export. The export process
> > > was accidentially overlaying an existing .dmp file which I need. From
> > > the log file, it recorded that the error terminated the process after
> > > it exported some of the user tables.

> > > Now, the questions I have are whether that .dmp file got written over
> > > by the 2nd export process? Or did it get written over half way? Can I
> > > still use it for an import? And is there anyway to fix the .dmp file
> > > if it got written half way?

> > > Thanks in advance.
> >  Your first file is hosed.

> So, actually is my .dmp file got written over half way because I still
> see my full size .dmp file around? And is there any way to salvage the
> file with this full size file?

Hi there,

You have to use the direct=n,instead of using the direct=y
otherwise,you might be meet this error message,again!

Lawrence
12/06/2001



Mon, 24 May 2004 22:05:22 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. EXP-00002: error in writing to export file

2. Another question for exp-00002

3. EXP-00002 error in writing to export file

4. EXP-00002: error in writing to export file

5. Help with ORA-00002 Error Message

6. US-PA: blue bell-Solid Oracle Developer, with DBA exp and unix scripting exp

7. Where is quicker for finding 1 to 1's, 'Exp = Exp' or Joining?, Newbie

8. Montreal: "C / Pro*C", programmeur avec exp en Oracle *** Programmers with Oracle exp.

9. MSSQL Exp/Imp question

10. Howto get a row by its number (as reported in a DTS imp/exp error)

11. Import .exp file to SQL Server?

12. MSSQL Exp/Imp question


 
Powered by phpBB® Forum Software