Re: Duplicate inserts but only through sqlplus

On Apr 11, 1:06 pm, "Anoop" <anoopkum..._at_gmail.com> wrote:

> SQL> set echo on
> SQL> set feedback on
> SQL> set verify on
> SQL> @c:/WSA_Domains_AM_april9.sql
> SQL> SET SCAN OFF
> SQL>
> SQL> insert into applications values ('WSA','Windows Server
> Admin','Windows Server Admin');
> 1 row created.
> SQL>
> SQL> /* Domains */

[snip]

>
> By Duplicates I mean that the data in some rows repeat in this step:
> insert into application_data values ((select max(application_data_id)
> +1 from application_data), 'WSA', 'Domain', 'cof.ds.xxx.com ', null,
> 0);
>
> So basically we find (after running the file) that cof.ds.xxx.com
> repeated twice instead of once. The file has only one row with the cof
> value - I am sure of that.

SQL> select * from dual;

D
-
X

SQL> /*
DOC>*/
SQL> / *

D
-
X

SQL>
>
> We have about 3000 insert statements in all. By putting commit
> statements in between we seem to reduce the number of duplicates, but
> I fail to see how that would help. Is it really necessary to add a
> commit after a specified number of inserts??

jg

--
@home.com is bogus.
New in 11g:  oracle flashmob
http://www.tokyomango.com/tokyo_mango/2007/04/video_cosplayer.html