forestq Posted April 8, 2013 Share Posted April 8, 2013 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. Link to comment Share on other sites More sharing options...
justsomeguy Posted April 8, 2013 Share Posted April 8, 2013 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. Link to comment Share on other sites More sharing options...
jaseervp@ymail.com Posted May 30, 2013 Share Posted May 30, 2013 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now