Hi , I would like to know if its possible to EDIT / UPDATE the Oracle Service name PATH= , via SAS SMC.    We need to update this name for the libnames to work in EG. Thanks in advance.   Path NEWSERVER10G (This value is contained in the tnsnames.ora file generated during the Oracle installation. The file is stored in an Oracle installation directory such as /opt/oracle/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora . The alias for the connection information is contained in this file. See the following figure.) ... View more

Hi , Need some advice on which type of methods can be used to efficiently and quickly delete a couple million rows in Oracle from SAS.   Some errors see during the course of action below. Error received on SAS - “ERROR: Update/delete failed. The observation may have been changed or deleted since the time it was read. ORACLE execute error:        ORA-08177: can't serialize access for this transaction. ERROR: ROLLBACK issued due to errors for data set XYZ NOTE: Deletes were rolled back by the DBMS software.” ... View more