Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Archiving data into another database
Thank you for the link. I believe this would work if we can get the code to
require a date range--that's what they want to use as the key for
archiving. The users who run ad hoc queries would have to be trained as
well. Very doable. I'm looking forward to testing this as soon as I can.
I have already talked about the cost of recoding vs. buying a different license. It fell on deaf ears. Won't stop me from trying again though once they've tuned the horrible SQL that I see every day. Picking my battles here.
Sandy
On 1/31/07, Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl> wrote:
>
> Which brings me to a reference to a link to the archives of this list:
>
> http://www.freelists.org/archives/oracle-l/06-2005/msg00782.html
>
> A post linking to 'poor man's partitioning' by Lex de Haan, who left this
> planet(R) at Febr. 1st 2006. It is a year ago, tomorrow. He's missed by
> many.
>
> Regards, Carel-Jan
>
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> ===
>
>
>
> > Having had good results with partitioning at my last job, that would be
> > my
> > preference. Unfortunately, partitioning isn't an option when using
> > Standard
> > Edition One as we are. The company isn't yet in a position financially
> to
> > pay the licensing fees for an editiion that supports partitioning. This
> > is
> > why I'm looking for other options. I still am leaning towards an
> archive
> > table in the same database.
> >
> > Sandy
> >
> >
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 31 2007 - 10:25:46 CST
![]() |
![]() |