Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Monthly Archives: May 2010
Aggregate Query, with Many Columns.
Someone wanted to do an aggregation (sum) on a table with many columns and one join. This stops them using the table.* select clause, unless you re-organise it a little.
ORA-00439: feature not enabled: Partitioning
This indicates that you are either using partitioning without having it installed, else you are on standard edition, where you are not allowed to use it.
CPU Jan 2010 Forms Home Installation.
Had a conflict when applying path CPU Jan 2010 to an oracle forms installation. First complained about conflicts. Metalink resolved the problem for me.
Obtaining x rows dual.
Connect by Level. Someone asked how to obtain a list of dates in the future for a table which does not have data yet. Interesting investigation….. (Thanks to Bruno Vroman)
ORA-19526: only one location allowed for parameter db_recovery_file_dest
ORA-19526: only one location allowed for parameter db_recovery_file_dest. Oracle 10g and 11g are supposed to allow multiple values in the db_recovery_file_dest, however this does not work and returns the above error. Here’s things I’ve found which cause this problem.
Posted in Configuration., Oracle
Tagged 10g, 11g, create~pfile~from~spfile, CREATE~SPFILE~FROM~PFILE, DB_RECOVERY_FILE_DEST, ORA-19526, PFILE, SPFILE
Comments Off
