Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.orgReceived on Wed Apr 11 2007 - 16:02:35 CDT