Re: Merge
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Joel.Patterson@xxxxxxxxxxx
- Date: Tue, 6 Jul 2010 10:48:49 -0700
On Tue, Jul 6, 2010 at 10:25 AM, <Joel.Patterson@xxxxxxxxxxx> wrote:
> Do I dare ask? Ok. Do you need to pay for partitioning option
> licensing?
>
>
>
Yes, you do.
Another way to do that (if you have the space) is to create a MV with the
data
you need, and then create another one, based on the initial MV.
Populating the 2nd MV from the 1st can be very fast. It is dependent on the
data and the query in question. I use this method to create a small table
from Oracle Apps data. The query to pull the data from apps is quite slow,
hence the second MV for external app use.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
