failure of export job
OS : Windows Server 2003
Oracle Version : 9.2.0.1
Hi friends, i am having an export job which need to run twice in a day. from past 2 days am getting following error.
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully
i checked for disk space and i am having enough space.
i am using parfile and the parameters in that file are as follows (actually this parfile is created by DBA who is there before me and am continuing that)
full=y
buffer=8000
consistent=y
constraints=y
compress=y
grants=y
indexes=y
rows=y
statistics=none
help=n
when i searched in google, i got the thing like bcz of consistent=y this may happen. but is this happen? also do i need to change any of the parameters?
am i getting problem with dump file size?
if so, can you please provide your idea of what to do?
thanks in advance.