On 5 Aug 2004, ibm_97_at_yahoo.com wrote:
> Oracle 9205 on Linux 2.1
>
> Our app INSERTs into DB 24*7, around 200 rows per second (only
> insert into 1 target table). What I want to do is to block the
> INSERT temporarily, and during the block period, I want to do:
>
> 1. rename the target table:
> rename target to old_target;
>
> 2. create new empty target table:
> create table target as select * from old_target where 1=2;
>
> So when INSERT resumes, the records can be inserted into the
> NEW target table.
>
> And during block period, I don't wanna get any error messages,
> like 'target tables doesn't exist'. Basically I don't want to
> lose any data from INSERT fired by our app.
>
> How can I do this?
Seems like what you really need is to partition on insert date
and then use the Oracle partitioning capabilities to handle this
cleanly.
--
Galen Boyer
Received on Thu Aug 05 2004 - 21:47:09 CDT
