Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

delete rows issue

sdk11Apr 6 2011 — edited Apr 9 2011
Hi,

What are the best ways to delete few million rows from a table keeping the table available for the loads and customer access? This table has 50 million rows, and I need to retain few months’ data and delete the rest. Please let me know if you have any ideas

Thanks

Comments

Christopher Jones-Oracle

cur.execute() will execute one SQL or PL/SQL call by sending it to the DB for execution.


Your code appears to be

1) passing in two statements. You need to pass each statement separately.  The BEGIN/END block counts as one statement.

2) passing a SQL*Plus SET command.  This is neither a SQL or PL/SQL statement so the DB won't understand it.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 7 2011
Added on Apr 6 2011
#advanced-compression, #data-warehousing
1 comment
1,315 views