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
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 |
KUP-04013: other system error
LPX-00662: Invalid encoding.
DRG-12210: error while adding section string
DRG-10313: logging has already been started
ORA-38766: cannot flashback data file string; file resized smaller
ORA-27371: jobs of type EXECUTABLE are not supported on this platform
ORA-25267: didnt specify the signature for a reciever non-repudiable queue
ORA-31417: column list contains control column string
PCC-00147: DBMS=V6 no longer supported; using DBMS=NATIVE
ORA-33030: (XSAGDNGL14) In AGGMAP workspace object, you can have either a single independent PROTECT statement or PROTECT statements in your RELATION statements.
DRG-50301: server error reading request queue
ORA-27150: attempt to notify process of pending oradebug call failed