| Loading 3,500,000 records [message #187605] |
Mon, 14 August 2006 12:02  |
superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico
|
Senior Member |
|
|
Hello:
I'm loading about 3,500,000 records in a table with sql loader, but when it loads about 100,000 the load fails with the follow message error:
ORA-01632: max # extents (505) reached in index DWH_MTP.DM08_PK_PERSONA
SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.
Specify SKIP=101991 when continuing the load.
Table "DM08_PERSONA":
101991 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.
I did:
alter table DM08_PERSONA storage (maxextents unlimited);
But I'm still having the error... Does anyone know why? My options are ok?
They are:
OPTIONS ( ERRORS=500, BINDSIZE=1000000, ROWS=1000000, READSIZE=1000000)
Thanks
|
|
|
|
| Re: Loading 3,500,000 records [message #187606 is a reply to message #187605] |
Mon, 14 August 2006 12:14  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| superoscarin@hotmail.com wrote on Mon, 14 August 2006 13:02 |
Hello:
ORA-01632: max # extents (505) reached in index DWH_MTP.DM08_PK_PERSONA
I did:
alter table DM08_PERSONA storage (maxextents unlimited);
But I'm still having the error... Does anyone know why? My options are ok?
|
But the error says maximum number of extents reached in INDEX, not TABLE.
|
|
|
|
|
|
|
|
|
|
| Re: Loading 3,500,000 records [message #190678 is a reply to message #187605] |
Thu, 31 August 2006 12:57 |
goudelly
Messages: 52
Registered: August 2006
Location: India
|
Member |
|
|
Hello:
I'm loading about 3,500,000 records in a table with sql loader, but when it loads about 100,000 the load fails with the follow message error:
ORA-01632: max # extents (505) reached in index DWH_MTP.DM08_PK_PERSONA
SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.
Specify SKIP=101991 when continuing the load.
Table "DM08_PERSONA":
101991 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.
I did:
alter table DM08_PERSONA storage (maxextents unlimited);
But I'm still having the error... Does anyone know why? My options are ok?
They are:
OPTIONS ( ERRORS=500, BINDSIZE=1000000, ROWS=1000000, READSIZE=1000000)
or
options(target=true)
It will load all the data from flat file
Thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
