if you want to implement something like this, your best bet is try something
like:
(*) every X days create a new table that you insert data into, and drop the
oldest table
(*) create a VIEW that UNIONs all of the current tables
(*) do all your inserting using the latest table name
(*) do all
gt;>
>>> Given your actual objective I'd guess you can create a fresh database
>>> each day, named using 'todays' date, and programmatically delete the 'old'
>>> ones.
>>>
>>> On 18 May 2017 at 09:48, Narendran Balasubramaniam <nare...@gmail.c
re...@gmail.com> wrote:
Hi,
Can someone let me know how to split H2 DB files based on
date ( daily files ). Checked H2 documentation and it
currently shows option to split based on Size.
Objective is to backup older dated fi
d using 'todays' date, and programmatically delete the 'old'
>> ones.
>>
>> On 18 May 2017 at 09:48, Narendran Balasubramaniam <nare...@gmail.com>
>> wrote:
>>
>>> Hi,
>>>
>>> Can someone let me know how to split H2 DB files based on d
gt; Given your actual objective I'd guess you can create a fresh database each
> day, named using 'todays' date, and programmatically delete the 'old' ones.
>
> On 18 May 2017 at 09:48, Narendran Balasubramaniam <nare...@gmail.com
> > wrote:
>
>> Hi,
>>
>> Can someon
guess you can create a fresh database each
day, named using 'todays' date, and programmatically delete the 'old' ones.
On 18 May 2017 at 09:48, Narendran Balasubramaniam <narenb...@gmail.com>
wrote:
> Hi,
>
> Can someone let me know how to split H2 DB files based on date ( daily
>
Hi,
Can someone let me know how to split H2 DB files based on date ( daily
files ). Checked H2 documentation and it currently shows option to split
based on Size.
Objective is to backup older dated files after a period of time and save
storage space.
Thanks,
Naren
--
You received