Re: Block DML!?

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Fri, 06 Aug 2004 02:35:56 GMT
Message-ID: <g8CQc.251981$XM6.109016@attbi_s53>

Why do you need the new table ? Can you do an online redefinition ? Then you can create the new table while the inserts are still happening.

See
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/tables.htm#ADMIN01501

JZ 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?
>
> Thanks a lot!
Received on Thu Aug 05 2004 - 21:35:56 CDT