DatabaseOracleUNIX Using cpio Some files that you get from Oracle download come in cpio format. Here’s what to do with them.... malcolmFeb 9, 2010
DatabaseOracleUNIX ERROR: NMO not setuid-root (Unix-only) Possible Cause : root.sh not run after the EM 10G installation. Fix: Check the permissions and ownership of... malcolmJan 22, 2010
DatabaseOracleSolarisUNIX Inappropriate ioctl for device and Oracle 10.2.0.3 I was trying to setup an instance of Oracle 10.2.0.3 a while back and was running into a... malcolmJan 7, 2010
DatabaseOracle Adding space to a tablespace One of the jobs I do the most as a DBA is added space to peoples schemas. It’s... malcolmSep 3, 2009
DatabaseOracle Enable Flashback in an Oracle 10g One of the cool new features of Oracle 10g is Flasback. “Flashback Database quickly rewinds an Oracle database... malcolmAug 27, 2009
DatabaseOracle Resetting the OMS password We’ve had an Oracle Manage Server (OMS) running here at work for some time now. I think it... malcolmAug 20, 2009
DatabaseOracle Sending Mail using PL/SQL I have been playing with Oracle Management Server at work receenty to try and mke the management of... malcolmAug 13, 2009
DatabaseOracle Export Problems in 10g OEM I was working with one of our Oracle 10g databases the other day when I tried to do... malcolmJul 30, 2009
DatabaseOracle Exporting data from Oracle Databases There are two ways to export data from an Oracle 10g database. Data Pump or the Export utility.... malcolmJul 16, 2009
DatabaseOracle SQL to show code of stored procedure I was doing some system checking the other day and I needed to find out what a certain... malcolmJul 9, 2009