Skip to Main Content

Oracle Database Discussions

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 from table

ChristianJun 29 2017 — edited Jun 29 2017

Hey,

my table does contain 13000000 rows.

I do have a timestamp in this table (creationdate)

I want to delete entries older than x days.

Is there a way to delete rows step by step without manual interaction

delete from x where creationdate < '31.01.11'

< '28.02.11'

< '31.03.11'

...

Something with rownum ???

Also any way of preventig redo logs ?

Chris

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2017
Added on Jun 29 2017
10 comments
3,887 views