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
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|
ORA-17618: Unable to update block 0 to version 10 format
NZE-29191: OID connection information not set
PCC-00123: Entire VARCHAR declaration must be on same line
TNS-12203: TNS:unable to connect to destination
ORA-04045: errors during recompilation/revalidation of string.string
DRG-50608: unexpected end of data
ORA-24085: operation failed, queue string is invalid
ORA-26011: Cannot load type string into column string in table string
ORA-23600: cannot create PROPAGATION, string already exists
LSX-00133: attribute "use" has invalid value "~S"
RMAN-06486: changed backup piece expired
PLS-00664: Both ORDER BY and CLUSTER BY can not be specified for the same table function