Re: Another oracle resource goes down the drain



Nothing but good statements/good advice in your response:

"This application should be completely re-engineered."

"An attempt to emulate the SQL Server behavior is not only a sign of
terminal stupidity, it will create a horrible application that will
invalidate dependent procedure and itself, create dictionary and
parsing locks, cause checkpoints and waste CPU on
reparsing."

"Oracle is not a SQL server and one should never make it behave
like that. That is how suboptimal applications are created." (kind of
like one of our applications that we have running here - it IS
horribly suboptimal; designed in a hurry by a SQL*Server "wizard" who
eventually quit)

Sometimes the truth hurts. One must learn to deal with it.

Regards,

Eugene Pokopac (Oracle DBA - GSFA - Tucker, GA)




.



Relevant Pages

  • Re: Equivalent of Oracles export/import in sql server
    ... I would not say a blanket statement like "Oracle DBAs should learn SQL Server" or "SQL Server DBAs should learn DB2". ... When I got a job as an Oracle DBA, I spent time learning how Oracle works keeping in mind that theory. ...
    (comp.databases.oracle.server)
  • select for update
    ... I am a Oracle DBA new to SQL Server. ... database running here. ... In sql server I try to do the same thing but it does not lock them. ... am also selecting the records in a cursor. ...
    (microsoft.public.sqlserver.tools)
  • Re: migrating Oracle database to SQL Server 2000.
    ... There are some articles about SQL Server for the Oracle DBA up on the MS ... Allan Mitchell MCSE,MCDBA, www.SQLDTS.com - The site for all your DTS needs. ... > I am an Oracle DBA and my client is interested in migrating Oracle database to SQL Server 2000. ...
    (microsoft.public.sqlserver.dts)
  • GK - Persmission on each database ( objects )
    ... As an Oracle DBA I'm not that familiar with scripting on SQL server 2000 so l need your help on this one. ... The netherlands. ...
    (microsoft.public.sqlserver.security)