ORA delete / truncate

[forestq]

Hi, I'm using SQL loader to load my data into database. Before I insert the data I need to remove existing data in the table:

options(skip=1,load=250000,errors=0,ROWS=30000,BINDSIZE=10485760)load datainfile 'G:1.csv' "str '^_^'" replaceinto table IMPORT_ABCfields terminated by "," OPTIONALLY ENCLOSED BY '"'trailing nullcols(....)

But I got error like: SQL*LOADER-926: OCI error while executing delete/truncate <due to REPLACE/TRUNCATE keyword> for table IMPORT_ABCORA-30036: unable to extend segment by 8 in undo tablespace 'undo1' How can I delete data for example by 10000 rows?I know that I have some limit on my DB.

[justsomeguy]

If I search for that error message, it sounds like you don't have enough space in the undo table and need to expand it.

[jaseervp@ymail.com]

If you are deleting data from a huge table, fire commit in a regular interval(eg: execute commit after deleting each 1000 rows). It will help to reuse the undo/rollback space