Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 6727 Views
- I also Faced
- E-Mail Answers
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 |
RMAN-06565: WARNING: string: sqlcode number was caught, automatic retry #number
ORA-02157: no options specified for ALTER USER
TNS-02508: Encryption: server negotiation response in error
QSM-00763: the owner string is invalid while validating user-defined workload string.string
SQL*Loader-00121: Invalid skip_unusable_indexes option
ORA-02324: more than one column in the SELECT list of THE subquery
QSM-02120: compatibility mode must be 9.0 or higher
LFI-00111: No other flags allowed in fixed length format.
ORA-12915: Cannot alter dictionary managed tablespace to read write
PLS-00608: the value of the USING clause must match that of the supertype
SQL*Loader-00650: incomplete lob data written for column string, row number, table string
ORA-31697: aborting operation at process order number string
Oracle Errors 
