Month: December 2007

This morning I had to solve an ORA-09925: Unable to create audit trail file and it was not as straightforward as usual… There is a note 69642.1 on Metalink, [edit]which is now up to date for 10gR2[/edit]. 1) AUDIT_FILE_DEST is not writable $ env _=/usr/bin/env ORACLE_SID=FOO TERM=dtterm ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_3 PWD=/u01/app/oracle/product/10.2.0/db_3 $ $ORACLE_HOME/bin/sqlplus -L “/ as sysdba” […]

I read a user question on forums.oracle.com this morning : As we know NOT EQUAL operations by pass indexes and cause full table scans in queries I did not know that. Do I need to use hints? set autotrace traceonly explain create table t as select sign(rownum-1) r, rpad(rownum,4000,’.’) t from dual connect by leveltrue) […]

Online Patching : you can apply or roll back online patches while the RDBMS instance is running 1) download an interim patch for 11g, f.ex. dummy patch 6198642 2) unzip p6198642_111060_LINUX.zip 3) cd 6198642 4) $ORACLE_HOME/OPatch/opatch apply -silent -connectString LSC08 -runSql Invoking OPatch 11.1.0.6.0 Oracle Interim Patch Installer version 11.1.0.6.0 Copyright (c) 2007, Oracle Corporation. […]

If I need to generate 3 rows called AAA, BBB, CCC, I could use dual and union all. Another method is to use Extensibility Types select * from table (sys.ODCIVarchar2List(‘AAA’,’BBB’,’CCC’)); COLUMN_VALUE ———— AAA BBB CCC

« Ask Tom Live » European Tour 2008  City Date Price Register Madrid 28 – 29 January € 924 ** Click here London 25 – 26 February £1,101 * Click here Berlin 6 – 7 May € 1,474 ** Click here * This price is valid until 31 January 2008 only ** This price is valid […]