Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Duplicate inserts but only through sqlplus
On 11 Apr 2007 12:17:29 -0700, "Anoop" <anoopkumarv_at_gmail.com> wrote:
>
>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.
This typically looks like a situation where some smart developer implemented integrity in the front end instead of in the database. And yes, in that case someone with direct access to the database can insert anything!!! Received on Wed Apr 11 2007 - 16:40:03 CDT
![]() |
![]() |