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
- 6718 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 |
TNS-04234: Trace Assistant WARNING: won't decode TTC
ORA-01104: number of controlfiles (string) does not equal string
ORA-10653: Table is in a cluster
ORA-02831: Segment deallocation failed - empty segment list
AMD-00131: dimension #string: RDBMS parent column data type not specified
ORA-16779: The destination parameter of some database has wrong syntax.
ORA-37076: (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT and NTEXT.
TNS-01067: Service display mode is string
ORA-24783: Cannot switch non-migratable transactions
ORA-14450: attempt to access a transactional temp table already in use
ORA-13010: an invalid number of arguments has been specified
PCC-01011: USAGE IS BINARY clause must be terminated by "." on same line
Oracle Errors 
