Jump to content

ORA delete / truncate


Recommended Posts

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 post
Share on other sites
  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...