Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


HI ALL, I AM FACING DATABASE ERROR EXP-00002 IN ORACLE 10G,
WIN XP OS. PLS HELP ME TO SOLVE THIS PROBLEM. AM NEW TO DBA
ACTIVITIES



HI ALL, I AM FACING DATABASE ERROR EXP-00002 IN ORACLE 10G, WIN XP OS. PLS HELP ME TO SOLVE THIS P..

Answer / dinesh

Answer: The docs note this on the ORA-0002 error, a generic file write problem:

EXP-00002: error in writing to export file

Cause: Export could not write to the export file, probably because of a device error. This message is usually followed by a device message from the operating system.

Action: Take appropriate action to restore the device.

This error is common when the expdp writing has filled the destination output file, as defined in the parfile.

Check the output file name in your export parameter file, and see the space usage.

This can also happen on 32-bit servers when the file size exceeds two gigabytes, requiring the use of the split command to separate the exp output onto multiple files.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-17618: Unable to update block 0 to version 10 format

1 Answers  


NZE-29191: OID connection information not set

1 Answers  


PCC-00123: Entire VARCHAR declaration must be on same line

1 Answers  


TNS-12203: TNS:unable to connect to destination

1 Answers  


ORA-04045: errors during recompilation/revalidation of string.string

1 Answers  






DRG-50608: unexpected end of data

1 Answers  


ORA-24085: operation failed, queue string is invalid

1 Answers  


ORA-26011: Cannot load type string into column string in table string

1 Answers  


ORA-23600: cannot create PROPAGATION, string already exists

1 Answers  


LSX-00133: attribute "use" has invalid value "~S"

1 Answers  


RMAN-06486: changed backup piece expired

1 Answers  


PLS-00664: Both ORDER BY and CLUSTER BY can not be specified for the same table function

1 Answers  






Categories