Kbase P25328: ORACLE error 1562 when loading records into the database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/19/2003 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Attempting to execute a 4GL program that loads thousands of records from an ASCII file into an Oracle database using Oracle DataServer.
ORACLE error 1562 see "ORACLE Error Messages and Codes Manual".(1252)
CAUSE:
Progress is creating a transaction that is big enough to blow the Oracle's rollback segments during the load process.
FIX:
Modify the code of the loader program to create smaller transactions.