I need to have table partion by range (date) and needs to perform partion
by year (or by quarter)
What is the best way to approach this and if you have example it would be
appreciated.
Also can this partion stay on same tablesapce. and any disadvantage on
doing so.

please advice.

Thanks


Oracle LazyDBA home page