Re: Duplicate inserts but only through sqlplus

Anoop wrote:
> Hi,
>
> We seem to have a mysterious situation here. We need to populate data
> into some tables and have created a file with insert statements. The
> file has been run through all our dev / test and staging environments
> with no problems, but it fails to run on production only. On further
> analysis we found out that the production DBA uses good ole sqlplus to
> run the file using @filename syntax and on all other environments we
> used Oracle's SQLDeveloper (Raptor) to copy paste the inserts and run
> them.
> <snipped>
> Thanks in advance,
> Anoop

Post the actual error message not your interpretation of it.

What you describe is not what is happening.

Please also include version number and the names and definitions of all constraints and unique indexes specifically mentioned in the error message.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org