Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

1 Answer
1

If you were using 11g, you could define the table to be interval partitioned in order to avoid having to create a new partition every day. But that's not going to help you on an ancient version of Oracle.