I want to do a range partition (by year) on our GL Postings table.

Do I need to create a new one like this or can you ALTER the existing
one? If create new, what's the best method to get the data from the old
into the new?

- Anthony


Oracle LazyDBA home page