Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Duplicate inserts but only through sqlplus

Re: Duplicate inserts but only through sqlplus

From: <sybrandb_at_hccnet.nl>
Date: Wed, 11 Apr 2007 23:40:03 +0200
Message-ID: <7blq1351fafpa17fm67cmqogkm3cj33apf@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US