| muzu |
Posted: Aug 29, 2007 04:00:34 AM |
Total Post: 37
Joined: Aug, 2007
|
while exporting the following error was encountered.
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00056: ORACLE error 1403 encountered
ORA-01403: no data found
Has anyone encountered this error before ?
Please let me know the solution for this.
|
|
|
Mohammed Taj |
| Posted: Aug 29, 2007 04:48:21 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Hi,
can you post your export scripts.
which table your export and what is definition of table
eg.(SQL>desc tablename)
regards
Taj
|
|
|
|
|
muzu |
| Posted: Aug 31, 2007 02:53:25 AM | |
|
Total Post: 37
Joined: Aug, 2007
|
The full database export was used here. Is it that i shud check each of the tables in the schemas to resolve this ?
also while exporting only the sys schema it gave the same error.
Does the export utility performs some conversions on the datatypes while putting the exported contents into the dump binary file ?
|
|
|
|
|
nick |
| Posted: Sep 11, 2007 03:02:43 PM | |
|
Total Post: 30
Joined: Sep, 2007
|
give a try with system user to export the table while database is in suspended mode.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |