Load data error
Hello!
We are trying to load 120 millions of rows into Oracle from MSSQL server table using SQL*Loader.
Getting error message:
ORA-01653: unable to extend table WEBECAPP.WEB_DOCUMENT_ELEMENT_LIST by 311072 in tablespace
PRODSPACE
SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.
Table WEB_DOCUMENT_ELEMENT_LIST:
89073399 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 62080 bytes(64 rows)
Space allocated for memory besides bind array: 0 bytes
Space allocated for memory besides bind array: 0 bytes
We checked space available after it creashed by running dba_free_space fro PRODSPACE tablespace and there is more than 300K space left there.
We ran 10 loads and all the time it's crashing with the same error message with approximately the same number of rows being inserted.
We tried conventional load, direct load with Data Saves option-didn't help.
Can somebody recommend what's the best way to load 120 millions of rows into Oracle table and how we can resolve this error?
Thank you,
Yelena